Viewing 15 posts - 49,381 through 49,395 (of 59,071 total)
If you are trying to split the lines into a table, why are you just returning the separators? Do you actually want separate rows in a table or???
If the...
July 6, 2008 at 11:31 pm
pallavikiran.deevi (6/10/2008)
Hi,Thank you very much for your reply.I used that code ,it works fine.I amso happy.
Regards,
Pallavi.
It would be better, in the long run,...
July 6, 2008 at 11:12 pm
MichaelC (6/5/2008)
I have been trying to debug a simple CLR function
Just curious... what does you "simple CLR function" do?
July 6, 2008 at 11:08 pm
Marios Philippopoulos (5/30/2008)
I have a SQL CLR sproc that lists the contents of a folder.
Just curious... what columns are you returning fo this?
July 6, 2008 at 11:06 pm
You still haven't answered the very important question of...
What have you written a CLR for that you think can't be done in T-SQL? Dude... 😉
July 6, 2008 at 11:03 pm
robert (7/2/2008)
SUM(CAST Duration AS datetime) wont work either...
Since that's basically the correct way to do it, tell me... what do you mean it won't work?
July 6, 2008 at 10:07 pm
It's a whole lot easier than you think...
SELECT Date-1
FROM Calendar
WHERE Day(Date) = 1
July 6, 2008 at 10:00 pm
Oh, no... sorry if this sounds nasty but I wouldn't use any of those... especially (sorry to say) the "Celko" version...
Try this instead, please...
First, create a function like...
July 6, 2008 at 9:16 pm
The bottom line is... if you expect the database to grow back to the same size in the next week or two, don't shrink it...
July 6, 2008 at 8:59 pm
I've already proven that it will return more than one NEWID()... just not the way you did it because the view only returns one row. Go back and look...
July 6, 2008 at 8:54 pm
ywb (7/6/2008)
July 6, 2008 at 8:31 pm
rbarryyoung (7/6/2008)
Vijaya Kadiyala (7/6/2008)
HiCheck out the below link
http://support.microsoft.com/kb/q139444/
http://www.sql-server-performance.com/articles/dev/dv_delete_duplicates_p1.aspx
Thanks -- VJ
Why?
I agree... WHY? The methods shown on those links do not accomplish the task requested (eventually) by the original poster....
July 6, 2008 at 8:27 pm
colin Leversuch-Roberts (7/6/2008)
July 6, 2008 at 8:22 pm
Note to self: Never interview with Jeff.
There is no doubt in my mind... you would pass with flying colors because you never lie. 🙂
July 6, 2008 at 8:21 pm
rbarryyoung (7/5/2008)
Jeff Moden (7/5/2008)
dakshinamurthy (7/5/2008)
I would also helpfull if i get to know what to do if we exceed the seed value for a bigint field in a table
If you...
July 6, 2008 at 8:17 pm
Viewing 15 posts - 49,381 through 49,395 (of 59,071 total)