I would perform three steps:

Step 1: get the vendor to permanently modify the .exe excluding the SQL Server stuff.

Step 2a: if they change it, set up your own proper SQL...

Before talking about how to write a cursor we should talk about what you'd like to do. In most cases a cursor can (and should) be avoided.

I would use a UNION to get all possible CompanyID as the left side of the joins and join all three other tables to that:

;WITH cte as

(

SELECT CompanyID

from Widgets

UNION

SELECT...

You should use variable with datetime type. It makes it a lot easier than dealing with the separate parts of a date value. It also helps performance since you don't...

I keep forgetting to check the forum a question is posted in... Sorry!! :blush:

Beside your sample data are not wellformed xml data (name tag with spaces), I'd use XQuery instead of openxml:

SELECT

c.value('column1[1]','varchar(30)') as c1,

c.value('column2[1]','varchar(30)') as c2,

c.value('column1500[1]','varchar(30)') as c1500

FROM @xml.nodes('NewDataSet') a(b)

CROSS apply b.nodes('Table')...

Or are you looking for a reference to the previons date with value=1000

DECLARE @t TABLE (reading_timestamp datetime,value int)

INSERT INTO @t

SELECT '06/09/2005', 1000 UNION ALL

SELECT '07/09/2005', 990 UNION ALL...

sqlservercentral 53898 (1/6/2010)

---

That looks excellent. Having a permanent calendar table makes absolute sense to me and your solution looks so much cleaner than mine.

I'll give it a try when I...

You need to divide by 5.0 instead of 5.

Integer divided by integer will result in an integer again...

BrainDonor (1/6/2010)

---

He reminds me of one of my kids - he'll put more effort into avoiding doing something than if he just did it and got it out of the...

Please have a look at the two articles in my signature regarding CrossTab and DynamicCrossTab. I guess you can't use PIVOT since your column names and number of columns will...

I used the following format file and it worked without any problem:

Please note the way I defined the dob column to be ignored.

9.0

4

1 SQLCHAR...

You would need a format file to exclude the dob column.

See BOL for details.

One thing he deserves credit for is the number of forums he knows to ask for help. :hehe:

After looking at your solution I found that I need to include the source_ID.

The basic concept of the join is pretty much the same you used. I just have a...