Have you checked to see if the values actually exist?

SELECT *

FROM (VALUES (CAST(0 AS DECIMAL(10,4)),CAST(0 AS DECIMAL(10,4))), (10,100), (20,NULL), (NULL,300),(40,400)

)...

You're welcome. Bear in mind that the triangular join method should only be applied when the partitions are many and small relative to the whole affected set, and you should...

You're welcome, you too! It's a bank holiday weekend here 🙂

Jeff Moden's paper here [/url]will show you how to correctly set up a Quirky Update, included iirc a partitioned update, which requires an extra variable. There are a few rules...

Which table contains the column which holds 'sales cost unit price'?

Have you thought about how the TOP(15) requirement will work? What if your user wants to see - and expand - a state node which isn't in the top 15?

Mimicing...

Only with major trickery, not recommended.

You could INSERT INTO #temp (column_list) EXEC sp, or alternatively reform the sp as a table-valued function, preferably inline.

Always truncating, never rounding? What about 12,589.99?

Your expected output omits a '$' character present in your first post, do you want this or...

shahgols (5/1/2014)

---

Hi all,

We have a very expensive query that I am tring to rewrite, but the rewritten query (even though is much faster) doesn't return the same number of...

SELECT

Starttime = CAST(Starttime AS TIME),

Endtime = CAST(Endtime AS TIME),

MinutesElapsed = DATEDIFF(minute, CAST(Starttime AS TIME), CAST(Endtime AS TIME))

FROM (SELECT Starttime = '09:45 AM', Endtime = '10:15 AM') d

vigneshkumart50 (5/2/2014)

---

Hi,

I am using this query to show my column as money and I need to remove the decimal values on top of this query

Query:

'$ '+ Replace(CONVERT(varchar,CAST(Finance_Report As money),1),'.00','') as...

ssurekha2000 (5/1/2014)

---

i think query is unclear

Transcation tbl has transcationdate, amount and cid

Mas_C has cid and cname

Transcation date displayed will be from & todate passed from the application

1) the output...

Unlikely - check the...

You forgot to initialise @strqry to something other than null. Since it ultimately gets concatenated to everything, the end result is null.

You've got three completely separate queries in there....

DROP table #sample

create table #sample (rowguid int identity ,id_frm int ,id_to int)

insert into #sample values( 1,5)

insert into #sample values( 7,13)

insert into #sample values( 17,20)

insert into #sample values( 30,1962)

SELECT...