Use the procedure "sp_helptext "

Well, reading excel data from within T-SQL requires many security related permissions such as enabling OPENROWSET configurations, read access to file etc..

So, my suggestion is to first import the excel...

Look for Partitioning Tables in Books Online....

Well, I could do that....

But first you have to help me by providing enough information about the objects (in form of DDL), the sample data (i.e. INSERTS statements) and the...

Winrar can do....

This looks promising. I just need to figure out where to find the msp files and give that a try.

I'm wondering if there may be a permissions issue that...

I'm assuming that the two tables are linked by some common column, as you have not provided enough information, here is the query which will does exactly what you have...

This is just another case of using "Dynamic SQL". You can't directly use a variable in place of object definitions...

You have to do something like....

--== Declare the link server...

You can use the "Data Flow Task" in SSIS and in that flow you need to set the source & destination connections & the mappings between them.

You can use the inbuilt "Send Mail Task" or embed the procedure call in an "Execute SQL Task" in SSIS.

Firstly, from where do I get the MEASURE_HOUR value? Does the DATE_PROCESS column will have time portions too?

Without much information, the sample data and the required outputs,...

Ok, here is the list of steps you have to do...

1. Create a variable "objQueries" (as Object data type, to store the resultset of SQL Task 1)

2. Create another variable...

Actually, you don't have to use any of them...

This can be easily done by using For Each ADO enumerator.

1. Execute SQL Task 1 (to get the list of queries from...

Hi Lynn,

I too had the same problem while installing SP2 on Developer Edition (64bit). I've fixed

that by manually copying the installer msps to the windows installer directories.

In your case,...

Or you can try using DateDiff("h", date1, date2)...