Hi, I have some xml files I want to load into SSIS. I use the XML source adapter. I generate an xsd for the xml files but on one I get the message: Error at...
4548
Noman Aftab
noman17pk
Aug 4, 2010 9:38 am
Hi, I am trying to call a function on a linked server with the following sql: --declarations declare @prefix varchar(1) declare @Code varchar(10) declare...
4549
p_livengood
Aug 4, 2010 5:31 pm
Noman; First Attempt - To my knowledge passing variable strings to the OpenQuery function is not supported. You might take a look at...
To get the results assigned to your local variable @cost you will need to use an output variable in the EXECUTE SQL statement. I believe the following should...
4552
Noman Aftab
noman17pk
Aug 9, 2010 6:18 am
Thanks again Paul, the OUTPUT parameter worked. (Y) Best Wishes, Noman Aftab http://www.corpus.quran.com/wordbyword.jsp http://www.jalandhari.qsh.eu ...
4553
santosh umarani
esantoshu
Sep 6, 2010 2:16 pm
Hi All, Can you please let me know how to use regular expression in SQL? It would be great if you can let me know with examples. Looking forward to hear from...
4554
p_livengood
Sep 6, 2010 5:04 pm
Santosh; There is no direct built in ability to use Regular Expressions in SQL, but you can write CLR functions using C# to help you with this. The code for...
4555
ganesh karki2000
ganesh_karki48
Sep 8, 2010 3:52 pm
hello friends!I hav a query regarding emp table...plz help me. how we can find the second highest salary from the employee table. what is the sql query for...
4556
Rob Richardson
interrobang
Sep 8, 2010 5:52 pm
I'm working in PostGreSQL v8.4. I have a query that I think is returning the standard deviation of a set of rows. But it's a bit complex, so I want to check...
4557
Noman Aftab
noman17pk
Sep 8, 2010 7:55 pm
Make sure your tutor is not on this group ;) Best Wishes, Noman Aftab ________________________________ From: ganesh karki2000 <ganesh_karki48@...> To:...
4558
Rob Richardson
interrobang
Sep 8, 2010 8:02 pm
What have you tried so far? RobR ________________________________ From: ganesh karki2000 <ganesh_karki48@...> To: SQLQueriesNoCode@yahoogroups.com Sent:...
4559
Rob Richardson
interrobang
Sep 9, 2010 12:52 pm
Thank you, Chandra. Since I was not the original poster, and the message I sent was directed to the SQLQueriesNoCode group, I am forwarding it to the group. ...
4560
Farhan Ahmed
farhan_4_love_u
Sep 9, 2010 5:10 pm
Hi, Select Min(Sal) from ( Select top 2 Sal from emp order by sal desc ) a This will help u alot. Thanks Farhan Ahmed Programmer Analyst The Shams Group ...
4561
nature strikes back
naturestrike...
Sep 11, 2010 5:39 am
i need oracle 9 or 10 for vista 32 is there anyone have pleaz tell me [Non-text portions of this message have been removed]...
4562
Chirag Mewada
chirag.mewada
Sep 11, 2010 5:39 am
hi u can use following query select employeeno from employee where salary = ( select MAX(salary) from employee where salary not in ( Select MAX(salary) from...
4563
Arindam
e_arindam
Sep 16, 2010 3:40 pm
This community has taught us a lot... I have enjoyed the journey.. Here i am introducing a utility for C# developer, which can help you develop your project...
4564
John Warner
john@...
Sep 16, 2010 3:59 pm
Is your link and server right, I get a blank page with no error messages? John Warner ... develop ... JSON, HBM, ... ...
4565
Arindam
e_arindam
Sep 16, 2010 4:02 pm
Hi John, did you click on the link below ..? It works ..let me know if any issue again.. Â ...
4566
Noman Aftab
noman17pk
Oct 1, 2010 6:26 am
Hi, I created a SQL job in SQL Server 2005. then I right clicked on the job and clicked properties. But it shows me "New Job" window. Is it a bug or I am ...
4567
Joe Fawcett
JoeFawcett
Oct 1, 2010 7:50 am
I seem to remember this was fixed by a service pack install, make sure you have the latest one for SQL 2005. -- Joe http://joe.fawcett.name/ ... [Non-text...
4568
Noman Aftab
noman17pk
Oct 1, 2010 4:43 pm
Thanks Joe! Best Wishes, Noman Aftab http://www.corpus.quran.com/wordbyword.jsp http://www.jalandhari.qsh.eu ... From: Joe Fawcett <JoeFawcett@...> To:...
4569
Bob Filipiak
bobfilipiak
Oct 20, 2010 4:47 pm
big surprise i just bought an Iphone4 from my friend they are in china , offerd thousands of new products hope you can try . chinese things are so cheap !! ...
4570
Arindam
e_arindam
Dec 6, 2010 3:58 pm
Hi All, i am getting the follwoing error after chaning the mdf file location .. can u please tell me what would be the solution ? TITLE: Microsoft SQL...
4571
Joe Fawcett
joe@...
Dec 7, 2010 12:38 pm
That can often be permissions based, Are you running the management studio as administrator (right click on shortcut to open)? Joe ... [Non-text portions of...
4572
Noman Aftab
noman17pk
Dec 9, 2010 6:52 pm
Hi, is it possible to infer primary key column name from table name in SQL Server using sysobjects and syscolumn tables? Assuming there is only column in a...
4573
Paul Livengood
p_livengood
Dec 9, 2010 9:30 pm
Try this SELECTTable_Name =OBJECT_NAME(c.Object_id),In_Key =CASEWHENkeys.Column_Name ISNOTNULLTHEN'Yes'ELSE'No'END,Column_Name =c.name ...
4574
Charles Carroll
charlesmarkc...
Dec 9, 2010 11:17 pm
(I have the traces if anyone wants them but I thought MAYBE some of you had encountered this in other contexts and had insight) *******************************...
4575
Noman Aftab
noman17pk
Dec 10, 2010 5:06 am
Thanks Paul, quite a huge text, but worth it. My main interest was in the following sub-query: SELECT Table_Name =OBJECT_NAME(t.object_id),Column_Name =c.name...
4576
Shadab Mustafa
shadab10
Dec 10, 2010 1:19 pm
I hope this works fine for your requirement. SELECT i.name AS IndexName, OBJECT_NAME(ic.OBJECT_ID) AS TableName, COL_NAME(ic.OBJECT_ID,ic.column_id) AS...
