KInd of related to this thread and kind of not - maybe somebody can tell me if I have an option...

Was running a query on a dev box - it...

Craig, I completely appreciate that the solution for 2 states is not the necessarily the optimal solution for n states and that you solved the stated problem.

If my last...

That's also a really neat solution and, funnily enough, just last night I was pondering how one would handle adding (for example) a "a DO X" in between my ...

Craig, excellent stuff - thanks a lot for taking the time. You're a cool guy.

Cheers

B

Am I on the right track at all here?

SELECT DISTINCT

A.EventID,

A.EventType,

B.EventType

FROM

(select

* ,

row_number() OVER (order by EventID, EventTYpe asc) as RowNoA

from dbo.tblEVENT

) as A

inner join

(

select

* ,

row_number() OVER (order by...

And one other question... what does one call (if anything) such a problem? 🙂

Ok I haven't given up yet I've posted the table and insert script below since there are currently people around willing to help right now 🙂

Sorry for not posting...

Hi there

Excellent - a definite clue!

I shall attempt to do it myself first (am a masochist) and failing that I'll post up some scripts

Many thanks

B

yes that is what happened with me - after I imported the dtsx I rescheduled one of the subtasks. Magically all the the other subtask jobs appeared.

BUT none of the...

That's interesting (and detailed) commentary. Not in a position to test right now so I'll ask you. No doubt like a lot of people here I'm looking to identify a...

Hi there

I took a maintenance plan (conencted to SSIS) end exported it to a file. I connected to a clean sql server and imported the dtsx file.

This created the...

Hi there

Thanks for that

Yes indeed - I gave up on getting dmo to do itand wrote a little function to insert the use statement into the scriptfile, save it and...