Hi lmu92 and ChrisM,

The main purpose for creating the query was to get the Stats count and Time Difference

between 2nd failure and 1st success.

Below is listed the result of your...

Hi LMU92

I refer to your post:

I'm by far not at the level of Jeff or Lynn, but I'll have a look at it if you're interested.

But since you specifically requested...

Hi Dhasian, thanks for your prompt reply, please view below some issues I have.

Your example only caters for either 1 or 2 Status Failure, not for 3 or more, view...

Thanks, will give it a try and post the results on this forum.

Thanks Lutz,updated as requested.

Hi Jeff, I have a stored procedure I want you to look at, its not an easy one which is why I am asking for your assistance. (Dont want to...

Sometimes its best to create separate jobs for:

backups of databases,

backups of logs,

db integrity check,

update of statistics

With integrity check & update of statistics, it depends how big your databases are,

if over...

Hi WayneS,

Thanks.

Since the date will always be previous date, I added everything directly to the script task in SSIS package. Will create a copy of current SSIS package and implement...

Hi, here is the winrar method I use. I posted the 7-zip method previously, to me both are the same, although I prefer the 7-zip method over the winrar method.

'...

Hi Wayne, my post is just below yours (Post #841757).

Can you have a look at it and reply with an example of variable for date.

Below I listed my method using 7-zip which seaches the folder c:\temp\out\xand its subfolders for all files with *_20100104.xls , only includes it in the zip file,

20100104...

Hi Carolyn, I used your article: Using SSIS to zip files and email the zipped files

By Carolyn Richardson, 2010/01/01. It works like a charm.

( http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64028/ ).

Below is the...

Hi Jeff, the query which I included in my post also worked.

WHERE LocationDateTime >= (CONVERT(VARCHAR(10), @StartDate, 120) + RIGHT(CONVERT(VARCHAR, @StartHour, 100),7))

AND LocationDateTime < (CONVERT(VARCHAR(10), @EndDate, 120) + RIGHT(CONVERT(VARCHAR, @EndHour, 100),7))

In...

Thanks Jeff, your solution worked.

Hi Lynn, can you shed some light !!!

DECLARE @StartDate datetime, @EndDate datetime, @StartHour datetime, @EndHour datetime,

@liTimeOffset INT

SET @liTimeOffset = 120

SELECT DateAdd(n, @liTimeOffset, LocationDateTime)

FROM mytable

WHERE

LocationDateTime >= (CONVERT(VARCHAR(10), @StartDate, 120) + RIGHT(CONVERT(VARCHAR,...