thanks David :-)... really good article... i m facing the archiving issue now...

sad, i got this one wrong... 🙁

2 options looked very likely ...

http://msdn.microsoft.com/en-us/library/aa173551(SQL.80).aspx

this was a very easy question...:-D

simple one, thanks 🙂

thanks Jack and Dave,

spent the entire day searching the logic of this useless number; finally i got the logic...

first 3 is year offset, next goes months, days, hh:mm:ss:milli --- 2,2,2,2,3...

nice question.. thanks 🙂

thanks Hugo for your comments.

P.S. i am male... 🙂

thanks for the question... i tried 8000 byte limitation with LEN function and even that throws an error.

Argument data type text is invalid for argument 1 of len function.

i guess...

thanks CirquedeSQLeil for the link... even with and without the indexes, query plan was exactly same... :w00t:

CirquedeSQLeil (1/26/2010)

---

Based on your provided reference, I would agree. However, if one examines...

thanks, i got my answer..

even after opening a new window, i got the result as 1,1 and i was wondering why ???

stewartc-708166 (1/28/2010)

---

when a new query window is opened, a...

i have executed the query on 2 different servers and for both of them i got the answer as 1,1...:(

easy one 😀

i m wondering, instead of using cursors, we could have used CTE...

thanks Andrew, this is better 🙂

this was a better question than the previous one... i m happy to get this one right 😀