What is the error?

This will explain the backup database command far better than I could. http://msdn.microsoft.com/en-us/library/ms186865%28v=sql.105%29.aspx

Try doing a backup and then a restore instead of the copy db wizard. I have never used it and didn't even realize it was an option until just now....

try this, this may help shed some light on where the problems are.

declare @flightId int

declare @flightTime DECIMAL(10,2)

declare @blockTime DECIMAL(10,2)

declare @ttEngine1 DECIMAL(10,2)

declare @tcEngine1 DECIMAL(10,2)

declare @ttEngine2 DECIMAL(10,2)

declare @tcEngine2 DECIMAL(10,2)

declare @ttAirframe DECIMAL(10,2)

declare @tcAirframe...

MaverickMan (4/30/2012)

---

Thank you all for providing such wide variety of solutions to this problem. Performance is not the need for our problem so it will work with any of the...

Longer than infinite? 😀

How many rows are you sending emails for? Did you populate the other variables with real info? @To, @From etc. It will probably take longer for error...

You added back in the while exists. That is your endless loop.

WHILE EXISTS (

SELECT *

FROM flightsClosed as a

left JOIN flightsClosed2 b

ON a.FlightID = b.FlightID

WHERE a.StatusTypeID != b.StatusTypeID

AND a.StatusTypeID = 44

--returns...

something along these lines?

select [DATA]

from TableA

where effectivedate = (select MAX(EffectiveDate) from TableA)

union all

select [DATA]

from TableB

where effectivedate = (select MAX(EffectiveDate) from TableB)

--EDIT: I didn't refresh before my reply...

I think something like this is close.

declare @flightId int

declare @flightTime DECIMAL(10,2)

declare @blockTime DECIMAL(10,2)

declare @ttEngine1 DECIMAL(10,2)

declare @tcEngine1 DECIMAL(10,2)

declare @ttEngine2 DECIMAL(10,2)

declare @tcEngine2 DECIMAL(10,2)

declare @ttAirframe DECIMAL(10,2)

declare @tcAirframe DECIMAL(10,2)

declare @profileName nvarchar(128)= 'I'

declare @To nvarchar(255)...

Well thankfully you ran into an issue with the temp table already existing. You coded an infinite loop. This is one of those rare time where a cursor is actually...

What Lynn meant is that you need to get the create table statements and any other objects (i.e. usp_cre_AddInsComplete). We only care about the sql portion of the process. The...

vikingDBA (4/30/2012)

---

Just did this last week for our developer. Is a table-valued function that returns a table with the values split out. Hope this helps.

(probably not very scalable,...

With 163 points and 618 visits you should know we need some information to help. ddl, sample data and desired output please. See the first link in my signature.

Capsized

You can't reference a column like that. You setup a cursor with its definition and then you get "NEXT" not column names. Instead of

FETCH LastModified FROM TEMPCURSOR INTO @STARTDATE

You...

k.subramanyam1017 (4/30/2012)

---

I'm really sorry for what I had done. I'm new to this and I have a doubt on this and so I posted that question, If any one knows...