I have tried on activity monitor as it shows wait type as IO_COMPLETION.

I have tried creating indexes on a table which i join while updating

but query still does not completing...

ChrisM@Work (9/14/2012)

---

Each option in the CASE construct, including the ELSE, must have the same...

ChrisM@Work (9/13/2012)

---

Try this:

declare @var int =2

select ClientInternalID, ClientName, NULL ParentInternalID

from TB_Client cl

CROSS APPLY (

SELECT OrderBy = CASE @var

WHEN 1 THEN CAST(ClientInternalID AS VARCHAR(10))

WHEN 2 THEN CAST(ClientName AS VARCHAR(10))

WHEN 4...

Thanks @ChrisM@Work

It worked 🙂

But what was wrong was is null sort or something else?

ChrisM@Work (9/13/2012)

---

Eugene Elutin (9/13/2012)

---

Man, you do really need to read the previous posts.

It's only going to work if you use dynamic sql.

Please note, if you run the following type...

Hi All,

The following did't work

declare @index varchar(10) = 2

select CityInternalID, CityDefaultName, CityCountryID from TB_City where CityCountryID = 121 order by case @index when 4 then CityZipCodes...

Thank you dwain.c

While using sp_executesql dynamic sql working well. I will be preferring dynamic SQL here.

Thanks dwain.c

I have following queries regarding this:

1. Here I don't have all parameters compulsory except city, so if i use this single query every time I will be join all...

Hi dwain.c

I am using IN clause because i have multiple values for countries and provinces.

and IN does not work with a variable without using dynamic query.

like select * from tb_country...

Hi All

right now I am using following dynamic sql code

to select a city Lat Long:

(Please suggest if there is better solution)

IF LTRIM(rtrim(@PostCode)) <> ''

BEGIN

select @ParameterList = ''

set @PtSql...

@dwain.c

I can Use IF/Else but there i'll have to use too many iterations,

Because @Country and @province may contain more that one value.

and each table City, Region, Country and Province contains...

Yes this is not sure whether any of parameter will contain value or not except @city or @zip.

and also I guess IN clause won't work with a variable containing multiple...

Yeah right 😛

that was mistake putting "DESC" instead of "ASC"

But my intention was "ASC".

😀

rhythmk (7/11/2012)

No issue.:-)

However one question.You did not mention which record you want.So if you want any specific record tweak the query little bit get the name of column for order...

That worked

Many Thanks @rhythmk 🙂