J Livingston SQL (7/8/2012)

---

...small sidebar

why

CONVERT( datetime , CONVERT( nvarchar , TT.TDDATE , 113 ) , 113 )

TDATE is a datetime...as below

CREATE TABLE [dbo].[INITIAL](

[TN] [numeric](15, 0) NULL,

[WH] [nvarchar](4) NULL,

[TDDATE] [datetime] NULL,

for...

SELECT *

FROM (SELECT ID = 1, somecolumn = '399,243.01' UNION ALL -- YES

SELECT ID = 2, '£399,243.01' UNION ALL -- NO

SELECT ID = 3, '39924301' UNION ALL --...

Shcherbunov Neil (7/9/2012)

---

ChrisM@Work (7/9/2012)

---

Shcherbunov Neil (7/7/2012)

---

Yes, but ONLY if you reference view (not table!) in your query. See code...

Shcherbunov Neil (7/7/2012)

---

Yes, but ONLY if you reference view (not table!) in your query. See code example in start...

zxxz (7/6/2012)

---

I just can't seem to get it right, can I? Thank you for your work; my experience with SQL does not go much beyond 'SELECT... FROM'. I simply tried...

SQL* (7/6/2012)

---

hi all,

Merge statement is giving performance difference when We are updating the records using merge vs first delete the desired records then run the merge statement query (it is...

Today's Random Worm!

Nature has a few more years' experience of horror than us.

NOOOOOooooooooo!!!

Shcherbunov Neil (7/6/2012)

---

So, after all I have only 2 questions:

1. Why query optimizer resist to use IX_v index so hard?? :blink:

2. Does it all mean that I just CAN'T force...

muthuselvi.devarajan (7/6/2012)

---

Hi,

I used case as below but im getting error

select Pay.DetailId, clm.AssetId,

case when Pay.DetailId IS null then isnull(clm.NoteIds,0) else isnull(pay.NoteIds,0)...

So are we. If you really want help with this, then take the time to read the forum etiquette article. It shows you how to post...

Bobby Glover (7/5/2012)

---

Probably an easy one but I have a table (TABLE A) which is nserting data into another table (TABLE B).

The data types on the tables are not in...

Of course. Only one row from LEAN will be used to update one row...

That's no ordinary fish Dwain, that's a biggun, it stands out from the crowd - like your...

I did, and it fails.

Test it against the sample data. Fix it, then add whatever...