Well the reason I need the key is because I think it is the key for solving the issue with the next piece of code I'm trying to run. Based...

Well the above seems to return two rows:

SPDATE ...

Ok, I'll try looking into it 🙂 Thank you very much for all the help!

Hmm I tried setting up the database using your code, but after running the query from before (this time referring to TimeSeries..SP rather than SP, since the original table is...

Yes, I think it looks something like this:

USE [master]

GO

/****** Object: Database [TimeSeries] Script Date: 05/12/2010 13:46:55 ******/

CREATE DATABASE [TimeSeries] ON PRIMARY

( NAME = N'TimeSeries',...

Thanks for the swift reply! What seems strange to me is that I have a few databases in my Databases folder, but the tables within these accumulate to a sum...

That would be the former, meaning that I'd be needing the results from Oct the 30th rather than no observations if it's missing the 31st 🙂

But actually I've gotten it...

Hi both,

I tried both the codes, but unfortunately they yield "0 rows affected" and "1 row affected" respectively (the 1 row is 11/28/2008 for some reason).

Do you have any suggestions...

Ok thanks alot - I'll try that out 🙂

I might add that executing the code seems to work when adding for instance "Top 10" after the SELECT. However, executing the whole thing takes way longer than I've experienced...