Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Querying Multiple Bit Columns Dynamically

    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...

  • RE: Querying Multiple Bit Columns Dynamically

    Errr, that seemed really simple! Here I am thinking functions and dynamical SQL...

    Let me test that code out

  • RE: Querying Multiple Bit Columns Dynamically

    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...

  • RE: Help with SQL PIVOT or CrossTab Query

    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...

Viewing 4 posts - 1 through 4 (of 4 total)