Viewing 4 posts - 1 through 4 (of 4 total)
Sean Lange (11/29/2011)
Gail has a great blog post on this type of query. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/[/url]
Thanks for the link. I tried searching before posting, but did not know exactly what to search...
November 29, 2011 at 9:38 am
Errr, that seemed really simple! Here I am thinking functions and dynamical SQL...
Let me test that code out
November 29, 2011 at 9:37 am
INSERT INTO [Features] VALUES ('sku1',1,1,1,0,0,0,0,0)
INSERT INTO [Features] VALUES ('sku2',1,1,1,1,1,1,0,0)
INSERT INTO [Features] VALUES ('sku3',1,1,1,0,0,0,0,1)
INSERT INTO [Features] VALUES ('sku4',0,0,1,0,0,0,0,0)
INSERT INTO [Features] VALUES ('sku5',0,0,1,0,0,0,0,0)
INSERT INTO [Features] VALUES ('sku6',0,1,1,0,0,1,1,0)
INSERT INTO [Features] VALUES ('sku7',1,1,1,1,0,0,0,0)
INSERT INTO...
November 29, 2011 at 9:11 am
Thanks a million!
I was really close on my own. I knew that I could use a CTE and possibly use the row_number() as an "index". I couldn't work out...
June 7, 2011 at 2:31 pm
Viewing 4 posts - 1 through 4 (of 4 total)