This?

; WITH CTE AS

(

SELECT DISTINCT SourceA

FROM #Temp1 T

UNION

SELECT 'NONE' AS 'SourceA'

)

SELECT *

FROM CTE C

ORDER BY CASE WHEN C.SourceA = 'NONE' THEN 1 ELSE 2 END , C.SourceA

Makes sense, but without sample data, its very very very hard to start coding. Please provide sample data.

If you are just looking for links to other articles that share...

this , may be?

; with cte as

(

Select ProdPath = t.ProdPath + '\'

from #TestTable t

)

select SUBSTRING(c.ProdPath , 1, CHARINDEX('\',ProdPath)-1)

from cte c

OP needs it to be pivoted, Dwain 🙂

How about this?

DECLARE @UserInputDate DATE

,@DateMinus2Months DATE

,@NumOfDays ...

What will be column names for the 2 rows?

There may be data with symbols like $ or e or . . ISNUMERIC is not a 100% solution for finding is the values are INTERGER-convertible.

Not something that is handy.. but sample data preparation should not take u more than 15 to 20 mins.

Im not asking you to post the whole SP. But minimum, i need ready-to-use create table scripts, some sample data and clear expected results.

i could sense, you need dynamic...

Here is the article on the netiquettes to follow while posting, if you have not read it already

How to post questions[/url]

With the number of visits and the points against your name, i would think that you know the the forum etiquettes.

Anways, as this problem interested me, im preparing the...

With 500 posts and 1307 visits i would expect you to put some sample data, create table scripts and expected results. Can you provide them?

How about this?

DECLARE @Tab TABLE

( ID INT , ColValue INT)

;

INSERT INTO @Tab (ID, ColValue)

SELECT 1, 23

UNION ALL SELECT 2,...

cphite (5/25/2012)

---

It would be possible to write something that could do that; but it's a bad idea. Whenever you're updating data - especially an entire column - it's better...

And i have based the order of the rows on SSN. If there are any ID columns that i can base the ordering on instead of SSN, use that instear...