A pattern splitter can help you with this and I hope that you can complete the solution.

Reference: http://www.sqlservercentral.com/articles/String+Manipulation/94365/

Select *

from #tbl_data

CROSS APPLY (SELECT TOP 1 Item

...

REPLACENULL() was introduced with SSIS 2012 and this is a 2005 forum. I still wonder why it took so long to include this...

I'm not sure how Alvin's query solved the problem as the LIKE operator will implicitly convert values into strings.

DECLARE @test-2 TABLE(

Numbers int)

INSERT INTO @test-2 VALUES(12),(75924),(75),(53756),(2354)

SELECT Numbers

...

I agree with Sean, formatting in the front end will help you with order and more format functions.

However, here's a shorter way to do it.

SELECT STUFF( CONVERT( char(11), GETDATE(), 0),...

Or you could continue to post more questions to learn more about SQL, even if...

Please provide DDL, sample data and expected results based on that sample data.

Check the following article to help you with the correct way to do it: http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

It's not an unbreakable...

nycdotnet (5/11/2015)

---

That's interesting. If I run this with execution plans turned on it does indeed do a clustered index scan with ID as the predicate from #TEST_A and do...

That's because you're executing the following in the dynamic code.

USE SomeDB;

CREATE PROCEDURE usp_Something

AS

...

As the error states, the CREATE (or ALTER) statement should be the first (and only) statement in a...

The best option is to store your full order number in separate columns so you don't have to worry about dividing it later (it's easier to join for presentation than...

What's not working? Why aren't you using parameters to execute sp_executesql? Why aren't you executing the dynamic code or at least printing it?

From what I understood, you don't need recursion or even a CTE. You're trying to unpivot your data to get an EVA model which might be a very bad idea...

What is sql?

Oracle NVL2() function would be great for this.

But since we don't have that functionality in SQL Server, IIF() presented by Phil or a classic CASE statement would do the job.

select...

Ed Wagner (5/7/2015)

---

Luis Cazares (5/7/2015)

---

The problem is that this newborn isn't really a newborn, but keeps asking questions and making comments that...

The problem is that this newborn isn't really a newborn, but keeps asking questions and making comments that show that he hasn't...