SQL + Everyday
Jul 20, 2005Can somone explain me how to run some procedure everyday at 22:00 in MSSQL.
This is not an Administrative Task, it's my procedure.
ADVERTISEMENT
Tips On EveryDay
Jun 13, 2008Hi Gurus ..
Could any one create a thread called Tips for the Day and Give any imports and complex query to learn on each and every Day ?
Thanks in Advance
Dana
How To Loop Everyday For Whole Year
Mar 5, 2012Wanted to get those who are absent everyday 365 days for the whole year of 2011. the procedure below is only for the present day. How could i get the list of all the days and those that are absent for each day for the whole year? how could i loop through it everyday.
DECLARE @TODAY DATETIME
DECLARE @TOMMOROW DATETIME
DECLARE @FUTURE DATETIME
SET @TODAY=GETDATE()
SET @TOMMOROW=DateAdd("d",0,@Today)
SET @FUTURE=(SELECT CAST(FLOOR(CAST( @TOMMOROW AS float)) AS datetime))
SELECT v.strViagID,
v.dtViagSDate,
v.dtViagEDate,
v.strDescription
FROMtblViaggi v LEFT JOIN tblEmp e ON v.strEmpIDFK = e.strEmpID
WHERE (@FUTURE <= v.dtViagEDate) AND (@FUTURE >= v.dtViagSDate)
Extracting Data From Csv With A Different Name Everyday
Jan 30, 2008I am new to SSIS and everything in it. I have been reading up on it but I am stumped. I need to do the following:
Automatically open a .csv file that will have a different name each day
Extract the data
Convert it to SQL format
Append it to it to an existing SQL table in my DB
Delete or move the .csv file to a different directory
Thanks for the guidance!
Matt
Copying 4 Million Rows Everyday
Mar 21, 2000In our database, we have a very large table that gets updated every morning, start of the day is copying 4 million rows from the fact table from previous date to today's date in the same table and then some other processing. It takes 1 1/2 to 2 hrs to do this. There is a dts package created to copy these rows into temp table and then to this fact table.
This table has more than 200 million rows
Any ideas on how to accomplish this without doing the copy twice and not running into locking problems.
Thanks for any suggestions.
How Can I Update One Database Automatically Everyday Based On Another One?
Sep 3, 2002Hi guys,
I need to update one table in database A based on the other database B, which is on a romote server. The requirement is to update it automatically at 12:00 in the mid-night everyday. Database A is MS SQL Server 7, and database B is Oracle database.
What's the best to implement it? I thinking to use trigger, am I right?
Thanks in advance for any advice.
Henry
How To Send Mail Everyday At 3:00 AM In SQL Server 2000
Feb 14, 2008Hello
I want some ides rearding sending mail at specified time. I want to send mail at everyday 3:00AM from SQL Server. I have stored procedure to send mail.
Thanks in advance
Hem
DTS From Excel File (excel Filename Is Different Everyday)
Sep 25, 2006Good Day to all,
Hope you could help me w/ my project.
Im creating a DTS Package. The source data will be coming from an excel file going to my SQL table. The DTS package is scheduled to execute daily, but the source data will be coming from different excel filename.
Example, today the DTS will get data from Data092506.xls. Then tomorrow, the data will be coming from Data092606.xls.
How can I do this? The DTS I've already done has a fixed source data file.
Please help.
Thank you so much.
God Bless.