I am not sure what you meant there about visibility.

A CTE only exists for the duration of the query with which is defined. You can't assign a value in a...

But you can access a local variable.

DECLARE @Start int

SET @Start = 3

;WITH NumberSequence ( MonthNumber )

AS (

-- Anchor Member

SELECT @Start AS MonthNumber

...

I know it is giving me an error, which I state.

The question is: can you assign the result to a local variable from inside the CTE.

Here is what the 2nd...

But you are not assigning the local variable from inside the CTE.

I know how to do it outside.

I am not really interested in how to get the monthly list. ...

Actually, that was a mistake that I fixed. Change the line "1 AS MonthPart" in CTE1 to "2 AS MonthPart".

I hadn't realized what the CTE was doing when...

What this CTE does is create comma separated list of months and put them on each row of months. This would be used for something else. I am...

I have no problem getting rid of it.

My problem is that I don't ever want the scripter to add the database name. It never should. Otherwise you couldn't...

That handled that issue.

Is there a setting for the adding the database to the Insert or Update scripts:

INSERT INTO [MyDEV].[dbo].[District]

...

Thanks, just wanted to make sure.

BTW, if I did want to make it unique, would I then use:

CREATE INDEX D_IX1 ON D(AID, DID)

Thanks,

Tom

That was what I thought, but wasn't sure.

Thanks,

Tom

Would I also have to reference the PK in D as well:

CREATE INDEX D_IX1 ON D(AID, DID)

Also, would it be best to have it "Unique" as well.

This normally doesn't happen....

Then maybe the foreign key constraint should be dropped and readded. Not sure how long that would take.

If you disable a constraint and reenable it and you then lose...

I am deleting the referenced records first, so if I just disable that table do the deletes then reenable the FK then all should be well?

Is there a way to...

That might work ok in this situation, where I only have 3 possible values.

Sorting doesn't matter as I am not going to sort by this one.

It wouldn't work as well...

The problem is that if I add the status into the Group By clause, even inside the ROLLUP function, it uses the status as part of the grouping - which...