Then once more my question to you is what is telling SSIS where to go and find those configurations?

Hey,

I would be really interested to know what that setting is...

I know that if you set results to text and copy and paste to excel it keeps your formats. But...

Hey,

Please post if you came right on this one

~PD

2 suggestions:

1 - with variables

declare @distinctQTY bigint

select @distinctQTY = count (distinct sign(Qty)) from x With (NoLock) where xtype= 'S' and status = 'LIVE') =2

declare @maxDayQtyGTZero datetime

select @maxDayQtyGTZero = max(DayDt)...

Any specific reason you are copying and pasting from SSMS to Excel?

I tend to agree, exporting works equally as nice, plus you get headers for free

~PD

hey,

Any news on why the sp is running slow yet?

~PD

Ahhhh, I did misunderstand....

Maybe consider using replication

Almost like a "current" table?

If that is the case, drop the table and insert into where current indicator = 'Y' should do. Just about the fastest method you gonna find

~PD

Ahhhhhh that makes sense and explains quite a lot.

Thanks

~PD

Havent worked enough with the SCD wizard to know it off by hand. But I havent heard of any kind of time settings.

Why dont you test with a small subset...

Thanks man,

I seriously get to write a lot of case statements for different reasons, such as 1/0 kind of fields, so I am always looking out for different more...

I have a really simple question for my half a braincell which has never been exposed to replication.

Can anyone explain why the gaps appear in identity columns. I really dont...

Hey,

There is an ISNULL function that you may consider using.

Select isnull(p.NAME, 'N/A') would do the same thing as the case statement.

Not sure it will solve your Null problem though...

~PD

Hey,

Remember that SSIS is case and space sensitive, so even if it may appear that nothing changes, something may in fact be changing

~PD

Dynamic SQL Pivot equivalent for the case statements would look something like so....

declare @colList varchar(max)

declare @selList varchar(max)

select @colList = COALESCE(@colList + ',', '') + RankingGroup ...