Viewing 15 posts - 17,161 through 17,175 (of 18,923 total)
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
I'm not... I thaught that there was a refference to the split function.. There is but it's not so easy to find out.
BTW the charindex is about the slowest method...
June 8, 2005 at 2:23 pm
Return must be an int
once you set the output parameter, it "returns" to the caller automatically
CREATE PROCEDURE dbo.sptest
@Par as varchar(9),
@w_o char(9) out
AS
Declare @Int...
June 8, 2005 at 2:17 pm
Viewing 15 posts - 17,161 through 17,175 (of 18,923 total)