I am amazed with the quality of answers on this site. Fast and accurate, but yet efficient code.

Thanks for the help

How to add one more condition that the table name ends with "Temp"

I am trying to do an inner join, so far no success yet.

What does changing the compatibility level do?

Thanks

This is for DR purposes.

I installed SQL server express on the XP box.

Now I can execute this from the command prompt:

sqlcmd -S SrvrName -Uusername -Ppassword -i C:\NWC\ExtLogNWCBldg.SQL -o C:\NWC\NWC_Data.csv

I created a bacth file and...

The database is already set to Simple Recovery.

Thanks all for the help..

I Created two folders: "ztest\1_day_ago" and "ztest\2_day_ago". I then have this batch file:

DEL C:\ztest\2_Days_Ago\*.* /q

MOVE C:\ztest\1_Day_Ago\*.* ztest\2_Days_Ago

MOVE C:\ztest\*.* C:\ztest\1_Day_Ago

sqlcmd -S myPC\SQLEXPRESS -i .\backup.sql

The SQL query "backup.sql"...

This is what I did:

At the source "server2"

Created a linked server (Server1)

Ran the follwoing query:

insert into Server1.Energy.dbo.Elect_XMain_Daily

select * from Elect_XMain_Daily

where Date_Stamp >...

CAST(PointValue AS dec(10,1))

This one was simple.

Thank you. Truly appreciate it.

Side question:

Is is possible to export the query resutls to ftp site? If yes, then can you point me to a "tutorial or web-page" that explains how it's done on...

Oops!. Sorry. You are right it is SQL 2005 running on Windows 2003 OS.

Is SSIS available on SQL 2003 server? Or is it DTS?

I don't have access to the server directly (at least not yet), so I could not check.

Thanks

I don't know how the rows are getting inserted, They are part of an application (not mine) that I am trying to build upon. Thanks

Lowell (9/22/2011)

---

techzone12 (9/22/2011)

---

Thanks for the...

Thanks for the code. I am looking at it. One of the requirments is to have one email for each event.

There probably needs to be some sort of buffering...