Viewing 3 posts - 1 through 3 (of 3 total)
Thanks for this article. Hope you can supply a link to download the csv file and ssis package.Thank you in advance again.
November 29, 2009 at 7:32 pm
#1085215
Gianluca Sartori (11/20/2009)
Alter Proc sp_Test (@a varchar(10), @b-2 varchar(10), @C varchar(10) = NULL)asSelect a, b, cFrom TestTableWhere a=@aand b=@band c=ISNULL(@c,c)
Alter Proc sp_Test (@a varchar(10), @b-2 varchar(10), @C varchar(10) = NULL)
as
Select a, b, c
From TestTable
Where a=@a
and b=@b
and c=ISNULL(@c,c)
This works, but it's not efficient.
Take a...
November 20, 2009 at 8:33 am
#1082276
you can try it
pivot
May 10, 2009 at 11:13 pm
#991892