Do you think if this wold help ?

CREATE FUNCTION dbo.IsNumericEx( @value nvarchar(max) )

RETURNS BIT

AS

BEGIN

DECLARE @isInt BIT

...

Please Look at below statement where There is anInvalid use of bracket and Select statement.

Your code is little bit confusing.

AppServerSource = (Select IsNull(t1.ServerName,t2.ServerName) as ServerName

I tried to fix as...

Here is my two cents.

You don't need a Case Statement. Just simple One Line Query would work fine.

declare @MyTable as table

(

Column1 int,

Column2 int,

Column3 int,

column4 int

);

insert @MyTable values (0,6,0,0);

insert...

SSCRookie,

Your logic is perfect. It is a good strategy to save some coding by using Full Outer Join and CASE istead of lousy Left/Right/Inner join and Union. Thanks for...

Select T1.ServerName, T1.ApplicationName, T1.ApplicationID, AppServer = 'Combined'

from Table1 T1

inner join Table2 T2 ON T1.ServerName = T2.ServerName

and T1.ApplicationID = T2.ApplicationID

UNION All

Select T1.ServerName, T1.ApplicationName, T1.ApplicationID, AppServer = 'Table1'

from Table1 T1...

Salute Sir capnhector

It took me a while to understand your final solution, however, could not understand fully 🙂

Thank you,

T_Dot_Geek

Unfortunately, both logic not giving a desired order.

capnhector (10/24/2012)

---

T_Dot_Geek (10/24/2012)

---

Create a new calculated SortID column and add it in order by clause

SELECT TaskID, BaseTaskID, SortID = Case When BaseTaskID = 0 THEN TaskID ELSE BaseTaskID END

order by...

Create a new calculated SortID column and add it in order by clause

SELECT TaskID, BaseTaskID, SortID = Case When BaseTaskID = 0 THEN TaskID ELSE BaseTaskID END

order by SortID

Appriciate your work Andy.

This excellent Trick to perform dynamic grouping and sorting.

Each single point has a very clear explanation and there is no mystery or left unexplained.

It is very easy...