WHERE CONVERT(date, t1.transactiondate) >=  DATEADD(month,DATEDIFF(month,'19800101',GETDATE())-12,'19800101')
AND CONVERT(date, t1.transactiondate) < DATEADD(month,DATEDIFF(month,'19800101',GETDATE()),'19800101')

John

Dan

The splitter function will do that for you.  It takes a delimited list and returns the elements one per row.

John

What are you hoping to achieve here?  Even if the NOCHECK option did overlook the foreign key violations, you'd get an error anyway when your try to turn NOCHECK off....

If you look in the errorlog of the server (assuming you're capturing failed logins in the errorlog), that will give you more details on why the logon failed.

John

How many rows are there in cvuReportingPeriod?

John

I wouldn't worry too much about the exact figures.  You're not expecting much growth, so you're not going to have all that many auto-growth event, unless you set the increment...

And please, please - take half an hour to learn the T-SQL syntax for BACKUP and RESTORE.  I guess that with the GUI, it fails and then you have to...

ORDER BY
    CASE
        WHEN [Group] IN ('Pres','Succ','Total') THEN 0
        ELSE 1
    END
,    [Group]

Edit - oooh, this is an SSRS question.  Sorry.  There must be a way...

    CASE TestType
        WHEN 'Language' THEN HighScore
        ELSE 0
    END AS [Language]
,   CASE TestType
        WHEN 'Reading' THEN HighScore
        ELSE 0
    END AS Reading
,  ...

This looks right:
WITH Visits AS (
    SELECT
         PID
    ,    VisitDate
    ,    VisitName
    ,    LEAD(VisitDate,1,NULL) OVER (PARTITION BY PID ORDER BY VisitDate) AS NextVisitDate
    FROM #person

Yes, it's possible.  You use output parameters to get the values from your different connection into variables, then you use those same variables as input parameters to your delete task....

Search this site for "splitter functions".  You can use a splitter function with "/" as the delimiter.

John

Phani

I don't suppose anyone has the sa password?

Changing the service account to adm may automatically give it sysadmin access, but I'm not sure of that.  You...