Viewing 15 posts - 91 through 105 (of 1,922 total)
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
June 13, 2012 at 9:17 pm
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...
June 12, 2012 at 11:45 am
this , may be?
; with cte as
(
Select ProdPath = t.ProdPath + '\'
from #TestTable t
)
select SUBSTRING(c.ProdPath , 1, CHARINDEX('\',ProdPath)-1)
from cte c
June 11, 2012 at 1:17 pm
How about this?
DECLARE @UserInputDate DATE
,@DateMinus2Months DATE
,@NumOfDays ...
June 10, 2012 at 6:09 pm
What will be column names for the 2 rows?
June 9, 2012 at 1:10 pm
There may be data with symbols like $ or e or . . ISNUMERIC is not a 100% solution for finding is the values are INTERGER-convertible.
June 7, 2012 at 11:13 am
Not something that is handy.. but sample data preparation should not take u more than 15 to 20 mins.
June 4, 2012 at 2:54 pm
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...
June 4, 2012 at 2:42 pm
Here is the article on the netiquettes to follow while posting, if you have not read it already
June 1, 2012 at 5:17 pm
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...
June 1, 2012 at 5:12 pm
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?
June 1, 2012 at 10:45 am
How about this?
DECLARE @tab TABLE
( ID INT , ColValue INT)
;
INSERT INTO @tab (ID, ColValue)
SELECT 1,...
May 31, 2012 at 10:07 am
cphite (5/25/2012)
May 25, 2012 at 9:33 am
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...
May 24, 2012 at 2:23 pm
Viewing 15 posts - 91 through 105 (of 1,922 total)