CELKO (11/19/2012)

---

Actually #Table2 has the date, but as its only to the minute, there are duplicates - and the order of TEXT2 does not help - see the last...

thava (11/19/2012)

---

just by curiosity the last...

Actually #Table2 has the date, but as its only to the minute, there are duplicates - and the order of TEXT2 does not help - see the last few lines...

Thanks Dwain and very useful - quicker than my cursor, and it gets the same results.

And posting that CURSOR just got me promoted to 'SSC-Enthusiastic'

The Irony :rolleyes:

OK so this may not be possible to get exact results in T-SQL, because, as pointed out above, there is no default sort, but here is the solution I'm going...

drew.allen (11/15/2012)

---

The problem is that your desired results require that your TABLE1 be sorted in a specific order, but the data provided is insufficient to enforce that order. You...

I'll try to express it better - but I'm beginning to think its a procedural not a set-based problem.

Take a row from #Table1

Match the first row (Minimum Date) in...

Brilliant, and it runs on the full-sized table in only 4 seconds.

Thank-you. Problem solved. 😀

I tried this as I have SSMS 2005 and SSMS 2008 R2 installed on the same machine.

opening SSMS 2005, I CAN connect to the 2008 R2 database.

When I check database...

After extensive search of MSDN and BOL, I (incorrectly) came to the conclusion that the only way to change the frequency was by scheduling a job to update stats.

Some obscure...

The dbo prefixing thing seemed to be a problem after changeover from SQL 2000 to SQL 2005, though what it was, I've forgotten.

I've always thought it is generally good practise...

Jeff Moden (10/1/2012)

---

t.brown 89142 (10/1/2012)

---

GETDATE() is just a function that returns today's date, as an example datetime.

You would substitute your date column names

SELECT CAST(CONVERT(VARCHAR(10), StartDate, 120) + ' 12:00:00' AS...

OK this is getting a little difficult to work out.

Just so we're working to the same definitions:

12AM is midnight SQL time '00:00:00' , 12PM is noon SQL time '12:00:00'

Also...

I couldn't glean any meaning out of the data at first - but now I realise it was stock price data! - probably way out of date now...