-- See how this starts off with a table and data in it?

-- If you had provided us the data in this format,

-- it would have made things easier...

Good article Jason! 😉

Unless all the tables have the same structure, you'll probably be better off doing this dynamically. SSIS loads the column mappings for the export, and if they're changing, it will...

What was only mentioned in passing was the performance mess that this would cause. The reason for this is that each stored procedure creates an execution plan based on what...

This solution requires the DelimitedSplit function:

CREATE FUNCTION [dbo].[DelimitedSplit] (

@list varchar(max),

@Delimiter char(1)

)

RETURNS TABLE

AS

RETURN

-- first, need to break down into separate items. See Jeff Moden's article: -- The...

CirquedeSQLeil (6/9/2010)

Declare @CounterTable Table (Table_Name Varchar(50), NumOccurrences int)

Insert into @CounterTable (Table_Name, NumOccurrences)

SELECT Table_Name

,COUNT(Table_Name) AS NumOccurrences

FROM INFORMATION_SCHEMA.Columns

GROUP BY Table_Name

HAVING ( COUNT(Table_Name) >= 0 )

Select Count(Table_Name) as...

Here's a set-based method that can be adapted into a table-valued function (Lowell's solution utilizes a scalar function). A TVF can be utilized with CROSS APPLY to get pretty dramatic...

This is the reason I do it... not only do I learn (from researching...

I'm not sure what you're after:

1. Are you running the procedure from SSMS, and you want to put the results into a text file with this delimiter?

2. Or do you...

Dan.Humphries (6/9/2010)

I think you're the...

The first thing I see that I'm confused by is that your query is actually doing a clustered index seek... with the DateAdd and DateDiff functions being used around the...

Great. Glad that I could help you out.

Please post the actual execution plan for this query.

See the link "Performance Problems" in my signature for how to do this.

Does this work for you?

I'm not sure that I follow what it is you are attempting. Why not just insert all the data in one set?

;WITH CTE AS

(

Select ...