Viewing 15 posts - 47,341 through 47,355 (of 59,064 total)
Peso (11/6/2008)
More explanation about problem is found here
How on Earth do you keep track of these things, Peter?
November 6, 2008 at 5:43 am
November 5, 2008 at 10:27 pm
Heh... no fair... you gave a nice short explanation... 😀
November 5, 2008 at 10:24 pm
It's a hierarchical sequence and I believe Mark has solved it using a classic recursive CTE.
November 5, 2008 at 10:17 pm
PADMAPRIYA3.G (11/5/2008)
I need to perform operations on the temporary table created.
What kind of operations?
November 5, 2008 at 10:14 pm
Leo (11/5/2008)
I think it shouldn't take that long.
That's about the amount of time I'd expect it to take. If you want to save a bit of time, lookup DBCC...
November 5, 2008 at 10:13 pm
It sounds like the developer wasn't using an account that had the necessary privs.
November 5, 2008 at 10:05 pm
krayknot (10/23/2008)
you should go for the Client - Server db architecture
Are you saying one client per Server???
November 5, 2008 at 9:53 pm
pramod.chauhan (11/5/2008)
thanks for quick reply.When i am converting a string into datetime for comparing it with a column which is datetime why is it giving error,
You could use the 3rd...
November 5, 2008 at 9:49 pm
I agree... triggers needed only on updates. Default of GETDATE() on a column takes care of inserts.
November 5, 2008 at 9:46 pm
And pray that the IDENTITY column isn't a PK...;)
November 5, 2008 at 9:38 pm
umanpowered (10/28/2008)
Thanks very much for the detailed row-update solution. I have to go through it and ascertain if I can implement it for my purposes. (Still a newbie...).
I implemented...
November 5, 2008 at 9:37 pm
gauravw (11/5/2008)
November 5, 2008 at 9:32 pm
Do you really need 2 years of info online? Is there no way to archive all but the last year's worth of info?
November 5, 2008 at 9:27 pm
Simon_L (11/5/2008)
November 5, 2008 at 9:12 pm
Viewing 15 posts - 47,341 through 47,355 (of 59,064 total)