If you're right, that's another good reason to use scripts instead of the GUI.

John

Like I said before, difficult to say without knowing what your expected results look like.  But, from memory, the splitter function returns the element and the ordinal position, so all...

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