Sounds more to me like there's a customer here with geographically dispersed offices who doesn't already have connectivity between those offices. Establishing that in such a way...

I would eliminate the dynamic SQL for the primary query, and use a cursor to traverse the primary query, and for each resulting record, use dynamic SQL to query the...

Now I see the difficulty. There's only one scenario where a solution is impossible - that of the end time being MORE than 24 hours beyond the start...

You're quite right! And that's why you're an "Old Hand", and I'm still an "SSC Rookie". I was able to make the same change to my...

Actually, I tried that code and it fails on syntax, due to the ORDER BY clause being present in a subquery. Try the following that uses table variables...

I'm lost as to why you would want to do that (especially at random), but what kind of result do you expect in terms of placing a date into anything...

Please don't think that I'm making you responsible for a data collection faillure - most of us are put into positions of having to make do with less than ideal...

For what's being asked for, how about the following:

DECLARE @DR TABLE (

Date_Taken DateTime,

Main_ID int,

Daily_RainFall int

)

INSERT INTO @DR VALUES('05/01/2005',194,142)

INSERT INTO @DR VALUES('06/01/2005',194,155)

INSERT INTO @DR VALUES('07/01/2005',194,132)

INSERT INTO @DR VALUES('08/01/2005',194,199)

INSERT INTO @DR VALUES('05/01/2005',196,333)

INSERT...

I took a look at your spreadsheet, and I see all kinds of columns for data that's easily computed. It also seems that every time someone has a...

This is actually fairly easy to do, and if we assume that the data is limited to a single school year, you won't necessarily need a calendar table. ...

While this appears to be solved, I was just wondering why use CONVERT or CAST? I would think that if you already have DateTime data types, why not...

Seems like a lot of effort for what's essentially a need to navigate a calendar, which suggests a solution that will work well provided the proper number of attendance characters...

Gwen,

I forgot to post the results from my query, which is attached in Excel format. I'm fairly sure this is what you were after...

Steve

(aka smunson)

:):):)

The pivot is an all at once kind of thing. It appears you're trying to do only one piece at a time, so take a look at the...

Can you post the T-SQL that provides this result?

Steve

(aka smunson)

:):):)

Gwen (6/4/2008)

---

Steve,

By using the aggregate function on the COMBINED_DATA field, I'm

getting multiple rows per property, rather than one row per...