nigelrivett (12/11/2012)

---

This does something similar but without the correlated subquery.

Depends on your data as to whether it is any better

SELECT AA.[Country Code],

SUM(extendedamount) AS Amount

FROM dbo.AllActiveAuthorised AS AA

WHERE dispatcheddate >= CAST('20121101'...

No, there are no LOOPs here.

You cannot force the order as per list in IN.

You should consider re-factoring your query.

One of the ways:

SELECT t.*

FROM @T t

JOIN (VALUES (1,'XYZ'),(2,'AAA'),(3,'PQR')) lst(rn,name)

ON lst.name= t.name

ORDER by lst.rn

Especially such default rude and non-constructive answers from...

Phil Parkin (12/11/2012)

---

WolfgangE (12/11/2012)

---

You misunderstood. I cannot use the house numbers in my query. That was just to show how the result should be. I have not only 1...

I'm glad to help. You are welcome!

The problem with your posted sample is lack of details. Would be really great if you could provide better DDL. What is PK of your table? What really makes your...

Sean Pearce (12/11/2012)

---

ALTER PROCEDURE [dbo].[usp_delete]

@tablename sysname,

@pid int,

@pidname varchar(10)

AS

DECLARE @sql NVARCHAR(MAX),

@Params NVARCHAR(MAX);

SELECT@sql = 'DELETE FROM [' + @tablename + '] WHERE ' + @pidname + ' = @pid;',

@Params = '@pid INT';

EXEC...

That is good, but only will work if one of the types is missing...

Provided sample is very basic, but should give an idea how to do what you want:

declare @sample table (id int, [type] char(1))

insert @sample select 1,'A'

insert @sample select 1,'B'

insert @sample...

Hope that following should help you:

SELECT tf.EmpNo, tf.ChkDate

FROM filesTA tf

WHERE tf.ChkDate BETWEEN '20121001' AND '20121005'

AND NOT EXISTS (SELECT 1 FROM SalaryDay2 sd2

...

I'm just guessing, but if such one would exist, google search would return it straight away...

Continuous discussion on this thread, kind of shows that people has nothing much to do...

:hehe:

I do agree with few different points of different posters...

I guess if such question is asked...

That is correct.

Why are you trying to use dynamic sql. It's look like you need full outer join:

SELECT ISNULL(t.Column_Name, v.Column_Name) AS Column_Name

...