I have mentioned in the script that this startegy depends on knowing future growth of your data.

In the application where I have implemented this I had an extra table which...

Using a table with numbers is best way

Nice article...

Using tally( or numbers table) is best way..Easy to code :).

Below is the sql to show how much cpu time and logical IO's it takes to find the customers who bought A,B but not C.

Also, I have done a performance...

Hi Jeff

It is just sum of 2 power (0 for A, 1 for B ,2 for C,3 for D ..and so on)..

Thus if you have all 3 codes then...

Sorry Firast day of week not Month*

Try this as well.But see what is you first day of Month.

declare @date date, @day varchar(10)

set @date = dateadd(dd,-5,getdate())

set @day = 'Saturday'

select dateadd(dd,case when val <= dwpart then 7-dwpart +...

select * from

(

select id,max(case when cd = 'A' then 1 else 0 end) + max(case when cd = 'B' then 2 else 0 end) + max(case when cd =...

select * from

(

select id,max(case when cd = 'A' then 1 else 0 end) + max(case when cd = 'B' then 2 else 0 end) + max(case when cd =...