Two...

Raul Undreiner (2/27/2013)

---

What am I missing?

Why would this work

SELECT *

FROM #MainQuery

WHERE column1 IN ('Value1','Value2')

and this not?

declare @var varchar(100)

set @TOB = '''Value1'',''Value2'''

SELECT *...

This would work as well:

SELECT CONVERT(datetime, '25/02/12 11:39:34', 3)

I am confusing myself now, must be getting tired. I will have to look at this again in the morning after getting some sleep.

But then again, hold on a bit, not working with a single digit day. Let me figure that piece out.

Not sure how to do this with SSIS, but if you load that date into a staging table and use SQL to convert the string to date, I know how...

Is this format consistent: Wednesday 27th March 2013? Always the day name followed by the the day as 1st, 2nd, 3rd, etc., then the full month name, then the...

Abu Dina (2/26/2013)

---

Sure, just add another step in your existing SQL agent job and add some tsql along the lines of:

DELETE FROM incident WHERE DATEDIFF(YEAR,CAST(getdate AS DATE), created) > 2

Maybe...

One change to your code would be this in the CTE:

SELECT TOP (100) ID

FROM dbo.TableA

WHERE TableAStatusTypeID IN (1, 5, 9) AND LastUpdateTime <= dateadd(ss, -300, @CurUtcDate)

ORDER BY LastUpdateTime ASC

Also, if you are attempting to populate columns of existing rows of data, INSERT is not what you want, you want UPDATE.

Looking at your dynamic code, you are trying to...

Post the DDL for the table(s) involved.

This will work:

DECLARE @ThisYear INT,

@ThisMonth INT;

SET @ThisYear = 2013;

SET @ThisMonth = 2;

SELECT

DATEADD(MONTH, @ThisMonth - 1, DATEADD(YEAR, @ThisYear -...

Is this a native backup or are you using third party software to compress the backup?

Really not enough information.

Partitioning really isn't used for performancing tuning queries. You need to look at the code and the indexes. Using the actual execution plans for the...

Really, isn't...