drew.allen (1/4/2012)

---

You'll need to post sample data illustrating the problem and the desired...

Compatibility mode? Fantastic 😀

Not sure. Perhaps a column list isn't required with a table source

USING #TradeVolumes AS Source --(TradeID, AnalysisTypeID, VolumeTypeID, [Hour], [Value])

other than that, the syntax looks ok.

I'd recommend writing and testing...

SQLKnowItAll (1/5/2012)

---

Cadavre (1/5/2012)

---

SQLKnowItAll (1/4/2012)

---

Thanks for that, but what I am really trying to get at in this post is not an...

Have a look at the result set from the following query - you should be able to quickly figure out what to do next:

DECLARE @Today DATE

SET @Today = DATEADD(dd,1,GETDATE())

SELECT @Today

SELECT...

kumar.sachu08 (1/5/2012)

---

I know i am fresher....and i am giving interview......i have only 1 years of experience.

then what should i do....when any interviewer asking like such type of question ?

Should i...

Why would you want more than one index on the same column?

drew.allen (1/4/2012)

---

Actually, why are you using a subquery in the first place. Doesn't the following give you what you want?

UPDATE PLU_1

SET DSPL_DESCR = replace ([DSPL_DESCR],'"','in')

WHERE AND DSPL_DESCR LIKE '%"%'

AND...

Probably something in the UPDATE part of your statement. How about posting the whole statement?

Replace comma plus space with comma, then space with comma. Or something similar which works with your data (test it).

Then use Jeff's splitter.

where VND_ID NOT IN (select VND_ID from PLU_1

Where len(DSPL_DESCR)=40

AND DSPL_DESCR LIKE '%"%' )

This is functionally equivalent to Phil's LEFT JOIN.

You could also use NOT EXISTS as a correlated subquery.

Your...

Marco V (1/4/2012)

---

Hello,

I got a database with a table (meterdata) which has little of 70 million rows. Often new rows are added to be precise every 15 mins from between...

erikpoker (1/4/2012)

---

Thanks for your replies.

A merge is not gonna work for me. What i'm looking for is a way to use a function and insert something somewhere within the function.

And...

DROP TABLE #Sample

CREATE TABLE #Sample (ID INT, PID INT, Name VARCHAR(10))

INSERT INTO #Sample (ID, PID, Name)

SELECT 1, 0, 'Ad' UNION ALL

SELECT 2, 0, 'Area' UNION ALL

SELECT 3, 1, 'List' UNION...

Them's big rows. Can you post the CREATE TABLE script?