cbrammer1219 (6/27/2014)

---

It is even messier than that, I created a ETL package that cleaned it up even more, but after importing all of the files I am processing, found there...

David Burrows (6/27/2014)

---

:ermm: Hope the job does not ride on this solution alone :pinch:

Just something I pieced together...

Sana4u (6/27/2014)

---

Please view the attached files it contains create table script which contains data also and there is one query which I have written for you to give you a...

What does your execution plan look like?

Are you running any CLR?

Are you running SSIS on this box?

Are you running SSRS on this box?

David Burrows (6/27/2014)

---

Third time lucky 🙂

WITH cte (itemID,ItemProgramPricingID,Price,Quantity,Points,ProgramCodeName,RowID)

AS (

SELECTipp.itemID,

ippv.ItemProgramPricingID,

ippv.Price,

ippv.Quantity,

ippv.Points,

p.Code,

ROW_NUMBER() OVER (

PARTITION BY ipp.itemID,ippv.ItemProgramPricingID,ippv.Price,ippv.Quantity,ippv.Points

ORDER BY CASE WHEN p.Code = 'STORE2' THEN 1 ELSE 2 END ASC)

FROMItemProgramPricing ipp

JOIN ItemProgramPricingValues as ippv on...

Are you confined to using server side trace to do that?

Or can you use extended events as an option?

Sean Lange (6/27/2014)

---

SQLRNNR (6/27/2014)

---

Sean Lange (6/27/2014)

---

Loner (6/27/2014)

---

I just had an interview. Someone gave me 3 tables and asked me to write a query.

I struggled it and could not come up...

Performance tuning is good for everybody. Though there are other things to consider when looking to tune reports besides just the tsql.

I would also recommend my book 😉

Sean Lange (6/27/2014)

---

Loner (6/27/2014)

---

I just had an interview. Someone gave me 3 tables and asked me to write a query.

I struggled it and could not come up with the answer....

We'll see.

Are you able to open the packages and try to run them manually?

If so, have you tried that to see where the package is getting hung?

Another thought on the matter.

The default collation on SQL Server will be different depending on the Windows Locale setting. This of course is before performing the setup for SQL...

Thanks Barry.

Here is another fine article on the OVER clause

http://www.sqlservercentral.com/articles/T-SQL/75466/

Much simpler than some of the questions from Andy of late. Really straight forward and is something that should be useful to all DBAs.