sqlfriends (12/8/2011)

---

I have a ssis pacakge, I would like to import two flat source files into one SQL table , I will call it TargetTable.

File 1 has an age column,...

You're welcome!

varunkum (12/8/2011)

---

where

CASE WHEN @PrmDateDim= 'CreationDate' THEN (Case WHEN L.SALESSTATUS = 1

...

I misspoke a bit...the subquery approach is even less performant than I first wrote, as the execution plan shows that it actually scans the #Member table 25 times. It has...

ChazMan's approach works, bit using the nested IN subqueries results in scanning the #Member table three separate times. It can be done in a single scan using an approach like...

Does the entire date range between PubStartDate and PubEndDate need to fall inside the range defined by your parameters? Or are you looking for overlap? If you're not including overlap,...

Yingchai, did you have any luck with this? Or are you still having performance problems?

mpaulus-1000078 (12/6/2011)

---

I restarted SQL Server and then re-ran the query multiple times only with the same item / location never swithing any of the values and get the same results....

NJ-DBA (12/6/2011)

---

NJ-DBA (12/6/2011)

---

With the limited info you provided, I can say it's likely that the peformance gain you are noticing is due sql server caching the execution plan and reuses...

What is the scope of these temp tables, #local or ##global?

bitbucket-25253 (12/6/2011)

---

In case Jeff Moden does not see your request, I believe this is the article he was referring to:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

The articles title is:

Tally OH! An Improved SQL 8K “CSV Splitter”...

Also, check out the MERGE statement syntax: http://technet.microsoft.com/en-us/library/bb510625.aspx

I just realized you need to summarize word count across multiple rows, so what I posted would need some reworking to be effective for that (although it should be doable,...

It would be good if you could post an example of what the desired output should be. Also, if you could post your sample data as INSERT statements that would...

Here's a quick stab at doing this with a tally table. Note that to run this code, you need to first have created the tally table using the code in...