Glad it worked for you.

--Thanks.

I can be wrong but I think dynamic SQL with the loop is the only way:

CREATE TABLE #Site (

site_id CHAR(2)

,location_id CHAR(4)

,[description] VARCHAR(100)

);

INSERT INTO #Site (site_id, location_id,...

tommyh (8/6/2012)

---

So here i was thinking this was a rewrite of the question we had 2 questions ago, since this question had the varchar(50) on str4 which would have fixed...

Then another way is to implement this as a "File Management" solution.

1....

Not sure why your LEFT JOIN didn't work but just to illustrate the idea:

--This is a list of All location groups

CREATE TABLE #LocationGroups(

LocationGroup VARCHAR(20) PRIMARY KEY

);

INSERT INTO #LocationGroups(LocationGroup)

...

dj1202 (8/6/2012)

---

After further review, I believe I understand your recommendation now. Are you suggesting that I input NULL or 0 values in the table, for all the location groups that...

When you saying "feed" do you mean files? Does the loader loads from actual files located on the server or network path?

You posted your question in SQL Server Development forum and you asked for sql function...

What report are you talking about? If this is SSRS report the VB.Net also has DatePart...

CREATE TABLE #WeekTable(

YearCol INT

,WeekCol VARCHAR(9)

);

INSERT INTO #WeekTable (YearCol, WeekCol)

SELECT 2009, 'wk1' UNION ALL

SELECT 2009, 'wk31' UNION ALL

SELECT 2009, 'wk52' UNION ALL

SELECT 2010, 'wk1' UNION...

One way is to use table.

Create table with 7 rows and 7 columns. Use odd columns and rows (1,3,5,7) as dividers set their width/height to the same value. Use...

What is the difference?

As far as I understand...

(S)he probably runs your entire code and...

I don't think ROWTERMINATOR should be pipe '|'. It should be '\r' or '&#92n' or '\r&#92n'. The latter is default.

^^ That is exactly what I thought but OP for some reason wanted to do it in the trigger.

1. Add IDENTITY column to the target table?

2. Forget trigger and update your column after whole...