Viewing 15 posts - 21,031 through 21,045 (of 26,484 total)
I think all the complaints are out of line. I answered the question correctly, and I didn't even try to run the code.
May 12, 2009 at 10:06 am
Okay, I'm done. Just so you know, there is almost always another way to accomplish a task, you just have to be willing to look for it, and sometimes,...
May 12, 2009 at 9:47 am
Jack Corbett (5/12/2009)
RBarryYoung (5/12/2009)
Kishore.P (5/12/2009)
use TableDiff.exe which is exist in C:\Program files\Microsoft SQL Server\90\COM.
for more info see SQL BOL.
The "/90/" indicates SQL Server 2005, was it in SQL Server 2000...
May 12, 2009 at 9:43 am
Okay. I made 2 copies of the AdventureWorks.Production.Product table in my SandBox database: dbo.Product and dbo.Product2. I then wrote the following code and ran it and had no...
May 12, 2009 at 9:14 am
Okay, I understand your requirement that the data be filtered on the other side, but you aren't answering MY question. WHY does it have to be a function? ...
May 12, 2009 at 9:04 am
John Esraelo (5/12/2009)
The reason for using the function is that the caller has to have a "select...
May 12, 2009 at 6:56 am
Jack Corbett (5/12/2009)
http://www.sqlservercentral.com/Forums/Topic714364-8-2.aspx
Then complains that I didn't provide a solution that meets...
May 12, 2009 at 6:52 am
You really haven't explained why it had to be a function. What is it you are trying to accomplish? How is(was) the function going to used? Depending...
May 12, 2009 at 12:29 am
I have to leave. I have a soccer practice to run at 6:00.
May 11, 2009 at 4:50 pm
John Esraelo (5/11/2009)
Msg 2010, Level 16, State 1, Procedure ADV_UDF_GetEmp_ID, Line 16
Cannot perform alter on 'ADV_UDF_GetEmp_ID' because it is an incompatible object type.
Does not let me modify the...
May 11, 2009 at 4:49 pm
Bob Hovious (5/11/2009)
With MY name on it ??? :w00t:
We referees don't give cards, players EARN them. That's where I get the adage "I may have a Yellow(Red)...
May 11, 2009 at 4:48 pm
What I haven't quite figured out is how the function is going to be used?
May 11, 2009 at 4:44 pm
John Esraelo (5/11/2009)
As I expected; the test for the view takes 20+ second to run and I have not tested it from running a function yet.. that's next
The function should...
May 11, 2009 at 4:43 pm
john.arnott (5/11/2009)
Jeffrey Williams (5/11/2009)
Alvin Ramard (5/11/2009)
Grant Fritchey (5/11/2009)
Suffice to...
May 11, 2009 at 4:41 pm
Bob Hovious (5/11/2009)
No rules?! Then why are you fingering your red card in a threatening manner, Lynn? 😛
I'm not fingering any red card. Oh, wait, you...
May 11, 2009 at 4:37 pm
Viewing 15 posts - 21,031 through 21,045 (of 26,484 total)