http://www.sommarskog.se/dynamic_sql.html

http://www.sommarskog.se/dyn-search.html

http://www.sommarskog.se/arrays-in-sql.html

Every time it's run.  Just like any other select statements using any type of objects.

It's a very good question.  We you test it, can you post the results to us?

TIA.

The users using the application need to see the results in QA??

I'm not following here .

So far Robert's solution seems to be the only...

I already wrote a test on this one.  And even at 1 000 000 executions I could not get a difference (consistent).  I was getting like differences like 3 MS...

Why not bcp the data out in a comma delemited format?.  Will save you some uneeded data manipulations!

I don't understand the 2nd delete in this code.  Were are deleting duplicates.  So 1 row will remain which means that there won't be orphaned rows.  Other than that it's...

This is the closest error I can think of in SQL server (which comes from a bad practice but I guess you already know that

Depends of how much data is required to be kept in the db.  If all you need to save is the adress of the company and it's phone numbers, etc. ...

Ya that should do it.  The explicit join is always better, especially in avoiding unwanted cross joins.  I was  just pointing out again that the exec (spname) can't work the...

Thanx for the info.  Will do that someday, again.  But not today .

Simple modification from my original answer :

SELECT UserID, DATEDIFF(S, '2000/01/01', ViewDate) / 1800  3600  AS NbrOf30MinsSinceSomeArbitraryDate, COUNT(*) AS Total FROM #Demo GROUP BY UserID, DATEDIFF(S, '2000/01/01', ViewDate) /...

Actually there's a way to use the ordinal positions and get the performance boost while still being safe. Consider this [LONG] code :

Private Sub CHARgerTreeViewSectionModules(ByVal ModNode