BCP

or

SSIS

The above link is about how to present your problem to this forum to attract relevant answers in timely matter. Otherwise you will need to wait for someone who has...

Here:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

roryp 96873 (2/23/2012)

---

I'm sure there's 100 different ways to do this, most of which are better than my solution, but here it is anyways.

select j1.child

from job j1

where j1.parent in (

select...

Can you supply ddl of tables involved and some data setup?

If you want the best performance possible I can advise you to do the following:

Create a separate table to hold InstrumentId and LastUpdateTime

Create light-weight triggers (after insert, update) on all...

Your requirements are not very clearly defined in any of your post, that is why you question is not attracting much attention on the forum. Also, the code you've included...

you cannot do what you've asked for, but your query does not need to have two sub-queries:

CREATE VIEW vw_slowview

AS

select quick.Instrument_Id,

MAX(quick.TimeDateUpdated) AS TimeDateUpdatedSlow

from

(SELECT Instrument_Id, TimeDateUpdated FROM dbo.tblFutures_Options

UNION ALL

SELECT Instrument_Id, TimeDateUpdated FROM...

May be I'm missing something, but requested YYYYMMDD is the ISO format supported by CONVERT:

SELECT CONVERT(VARCHAR,GETDATE(),112)

The above will convert any DATETIME value into VARCHAR formatted as requested!

Then you can cast...

Divine Flame (2/23/2012)

---

Divine Flame (2/23/2012)

---

Did you try this?

If you just need to reset the ID column (with names in order) so you can simply add an IDENTITY column in...

Yes, you are right.

Raising error with severity less than 10 is the mechanism to return messages back to the caller. If called from within TRY block they will not transfer...

Why not to use IDENTITY?

The following code will do it, but will only work properly if your Names are unique:

UPDATE t SET Id = n.Id

FROM #temp t

JOIN (SELECT Name, ROW_NUMBER()...

Do not re-raise the error in your CATCH block, then calling stored proc will have no idea about any error happened in the called proc.

Is is not possible using cursor.

If you...

Gail is right, if you have reuired results stick with the working query.

But, if still want to do:

SQL_Surfer (2/22/2012)

---

...

How can I rewrite the version 1, without putting "b.BMonth= 2...