Viewing 15 posts - 41,671 through 41,685 (of 59,067 total)
To continue the car analogy... one should at least know which side of the road to drive on and maybe how to put the car in "drive".
--Jeff Moden
Change is inevitable... Change for the better is not.
October 3, 2009 at 11:22 am
This will help get you started...
http://www.sqlservercentral.com/articles/T-SQL/63003/
--Jeff Moden
Change is inevitable... Change for the better is not.
October 3, 2009 at 11:17 am
rockingadmin (10/3/2009)
Hi,file stream was introduced in sql2008. I am bit eager to know, what about earlier versions of sqlserver2000 and 2005?
i thank each and every one for sharing ideas.
Regards,
Rock..
For files...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 3, 2009 at 11:13 am
I'm always curious about what people use CLR's for. What does this one do?
--Jeff Moden
Change is inevitable... Change for the better is not.
October 3, 2009 at 11:07 am
bitbucket-25253 (10/2/2009)
Jan Van der Eecken (10/2/2009)
Is this fair use of the forums by the way?
Well we might soon know. Sent an email to the web master for...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 3, 2009 at 11:01 am
Jack Corbett (10/2/2009)
Jan Van der Eecken (10/2/2009)
Is this fair use of the forums by the way?
I don't have a problem with it. The OP isn't directly trying to sell...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 3, 2009 at 10:57 am
Roger Abram (10/3/2009)
I did figure it out.
Would you mind posting what your final code is? Thanks.
I am setting it up to use in the body of an...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 3, 2009 at 10:51 am
ItalianOlgi (10/3/2009)
Also, I am looking for information like "if they ask about X, first answer...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 3, 2009 at 10:39 am
Thanks.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 3, 2009 at 7:52 am
What's your handle there?
--Jeff Moden
Change is inevitable... Change for the better is not.
October 2, 2009 at 8:20 pm
Heh... Same here... abbreviated post. Looking back at it, I certainly could have made it more apparent that it was directed at the OP. Sorry.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 2, 2009 at 8:14 pm
BTW... you can also use a WHERE NOT EXISTS against a Tally table and it'll be fast as well. Just don't try the ol' outer join with a NULL...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 2, 2009 at 8:03 pm
Dave Ballantyne (10/2/2009)
select CASE
WHEN dateadd(year, datediff (year, d1, d2), d1) > d2
THEN datediff (year, d1, d2) - 1
ELSE datediff (year, d1, d2)
END as Age
I'll take...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 2, 2009 at 7:38 pm
Congrats on the book.
As a side bar, you should post more often... lot's of folks could use your help.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 2, 2009 at 5:28 pm
max-1156434 (10/2/2009)
i was just having the same problem. Weird thing is, I looked for the lines causing the problems, and copied a couple of "bad" ones and a couple of...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 2, 2009 at 5:25 pm
Viewing 15 posts - 41,671 through 41,685 (of 59,067 total)