Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KingCarlos
Yak Posting Veteran
74 Posts |
 Posted - 2012-01-18 : 20:03:54
|
| Hi there I have the following SQL Query that I wish to run as a SP can anyone point me in the correct directioninsert into Warranties (cid, contid, dwdate, serialno)SELECT cid, contid, dwdate, serialno FROM items WHERE DWARRANTY >= dateadd(day, datediff(day, 0, getdate()), 1)and DWdate < dateadd(day, datediff(day, 0, getdate()), 7)thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
KingCarlos
Yak Posting Veteran
74 Posts |
Posted - 2012-01-18 : 21:00:32
|
| Thanks - If I am running SQL Express is there any way to have this stored procedure to run every day? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2012-01-19 : 04:22:17
|
| I don't use SQL Express, but I thought there was an add-on available similar to SQL Agent in the main SQL product? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2012-01-19 : 13:43:45
|
| Sorry Tara, I should have Googled before posting. No such MS SQL Agent for Express, plenty of wannabe solutions ... but Windows Task Scheduled and SQLCMD or somesuch is the best alternative, albeit a bit "pants" compared to SQL Agent. |
|
|
|
|
|
|
|
|
Stored Procedure to find data and insert