It works perfectly fine, the problem is that you're using 2 characters and stripping just one. You need to change the third parameter from the STUFF function.

To get better and...

I'm leaving you with 3 options. The third might be the best, but you have to test them.

declare @CODE varchar(32);

declare @Work varchar(32);

SET @Work = 'CASUAL'

SET @CODE = 1000

--Option 1

SELECT *...

This article explains what you need to do.

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Be sure to use it only for display and don't store the concatenation in the database.

Notes:

You can use CHAR(10) + CHAR(13) for...

In this case, you can update the CTE without problems. You just need to add the column you're updating.

WITH cte AS (

SELECT ID, patientid,admissiondate, dischargedate, lastdischarge,

...

Maybe you're looking for something like this:

Select *

from @new n

WHERE invoice_id IN( SELECT i.invoice_id

...

You can use a table valued constructor to simplify it

select Username

, (select max(choice) from (VALUES(column1 ), (column2), (column3), (column4),

...

Here's an option on how to do it.

CREATE TABLE Customer(

custid int,

firstname varchar(50),

lastname varchar(50),

zipcode varchar(10))

INSERT...

That seems fine to me. An alternative could be:

Case when Server_Excluded <> 'Yes' and Aged30 > 0 Then 'Green'

when Server_Excluded <> 'Yes' and (Group= '' OR...

Here are two options:

CREATE TABLE Fun_Test( Somepath nvarchar( 50 ));

INSERT INTO Fun_Test

VALUES

( 'C:\QA\Documents\pdf1' ),

( 'C:\QA\Documents\pdf2'...

Grant Fritchey (10/28/2014)

---

jeffgonzalez007 (10/28/2014)

---

I think I'm going to start with SQL Server 2012. I'm not seeing to many books out there yet on the 2014 version. For 2012 I definitely...

Scott always tell me not to rely on date settings, but I keep doing it :-D. This is a different way to achieve it with a single script.

CREATE TABLE TestDates(

...

Then create a new one and test for differences....

David,

Note that this is a 2 year old thread. That said, your code can be improved to avoid errors if table or column names have spaces or other characters. You...

This is a possible option based on Scott's post. You might need to use additional validations and things can get really complex really quickly.

SELECT

TextID,

...

Take a look at this article. It shows what's happening and how to get an all-digits validation.

http://www.sqlservercentral.com/articles/ISNUMERIC()/71512/