Viewing 15 posts - 17,161 through 17,175 (of 18,926 total)
The simplest solutions are always (almost) the best.
HTH.
June 8, 2005 at 3:03 pm
I'm wondering if he's talking about using sp_executesql for this??.. we'll see.
June 8, 2005 at 2:47 pm
Select id, min(DateCol) as EarlyDate
from dbo.YourTable
Group by id
June 8, 2005 at 2:45 pm
How do you know where the decimal starts?
Also I feel I must mention that this presentational stuff should be made at the client.
But if you insist on doing it on...
June 8, 2005 at 2:43 pm
Hehe.. I missed that one (referencial integrity). But I think it's the best reason to stop (or not start) this non-sens. Not to re-mention speed, ease of use,...
June 8, 2005 at 2:37 pm
Not even close to MVP... Don't have a single certif, nor 25% of the knowledge of dts, backup/restore, DR, Security and under the hood workings of sql server that Frank...
June 8, 2005 at 2:34 pm
Well mostly because it avoids dynamic sql altogether. Also it avoids doing 14 proc calls lessening the load on the server and on the network.
June 8, 2005 at 2:31 pm
Well I'm out of ideas.. so I'll have to wish you good luck with this problem...
June 8, 2005 at 2:28 pm
I'll sleep on it and watch it again in the morning
.
June 8, 2005 at 2:28 pm
Viewing 15 posts - 17,161 through 17,175 (of 18,926 total)