If I understood what you're trying to do, this is a more efficient approach.

SELECT n.[ID], n.DisplayTime, n.NEText, c.Other_ID

FROM @Case2 AS c

CROSS APPLY (

SELECT TOP (1) n.ID, n.DisplayTime, n.NEText

FROM @Notes AS...

The problem occurs because of how the precision and scale of the result are determined from the precision and scale of the operand expressions. Check Precision, Scale, and Length...

I don't think it's that easy to...

There may not be syntax errors, but there are lots of logical errors. For instance, the table clean_cust_account_lcd_cancel_switch is queried three separate times when it looks like it should...

Jeff Moden has an article on this very subject. String Splitter[/url]

Drew

It has been shown repeatedly that the loop performs much worse than the string splitter that was linked to previously in this...

The problem with this query is that the order of the UOMs is not meaningful. It just happens that the UOM for capacity comes before the UOM for weight...

stourault (12/22/2011)

---

Also, I apologize, but I seem to have lost the formatting of the results set that I put in the post, I'm trying to figure out how to show...

Jeff Moden has a very good article on exactly this problem. Solving the Running Total and Ordinal Rank Problems (Rewritten)[/url] Be sure that you follow all of the...

Use NTILE() to divide each partition into two parts (control and experimental) and then use ROW_NUMBER() to assign a number to each record within the group and match corresponding numbers....

We're all unpaid volunteers. We're more than willing to help as long as you've...

This goes back to...

Actually it sounds like he wants to overwrite the existing column if both the existing and...

The problem is this line here:

CAST ( ( SELECT td='<a href=''http://ABC:7777/XYZ/TYPE/EditForm.aspx?ID=0&UID='''+CAST(ACTIVITY_UID AS VARCHAR(36))+'''''>'+ACTIVITY_NAME+'</a>','',

Because you have given it an alias ("td") it treats the data as text instead of XML....

This...