Viewing 3 posts - 1 through 4 (of 4 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 varchar(10), @c varchar(10) = NULL)asSelect a, b, cFrom TestTableWhere a=@aand b=@band c=ISNULL(@c,c)This works, but it's not efficient.Take a look at this article:http://www.sommarskog.se/dyn-search-2005.htmlRegardsGianluca
Gianluca Sartori (11/20/2009)
Alter Proc sp_Test (@a varchar(10), @b 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 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 look at this article:
http://www.sommarskog.se/dyn-search-2005.html
Regards
Gianluca
it's...
November 20, 2009 at 8:33 am
#1082276
you can try it
pivot
May 10, 2009 at 11:13 pm
#991892