'Welcome Seth 🙂

In addition to correcting the error pointed out by...

Did you test the code I posted, Viji?

There are too many errors in the code to list them all, this should work:

[font="Courier New"]WHERE locationkey IN (SELECT locationkey

   FROM dbo.ClientTbl_DimStores

   WHERE (CASE @StoreAttribute

       WHEN 'Country'...

Hi Sanjay

I'm still not totally sure of your requirement but try this - it will generate the sort order you're expecting from the given sample data.

DROP TABLE #Temp

CREATE TABLE #Temp...

Heh - yeah, think so. I didn't read it properly first time. "1" first, followed by everything else...

ORDER BY RIGHT('00000'+MyColumn, n)

where n is the length of you column. Ensure that there are enough 0's.

What is the datatype of p.birth_date? Can you provide a few sample values?

Lynn Pettis (12/12/2008)

---

Jack Corbett (12/12/2008)

---

I like tabs and I use 6 and I like to set it to 6 even if I change set it to use spaces. One...

Steve Jones - Editor (12/12/2008)

---

Why did this thread start?

I think Gail's on the Kalen track of working entirely too much. Guess that's why she goes to throw people around on...

karthikeyan (12/12/2008)

---

ok.

but if we have unordered data...what will happen ?

you sample data has ordered, so we no need to worry about the result...

i think we can use ORDERBY clause...but again...

karthikeyan (12/12/2008)

---

ok.

but if we have unordered data...what will happen ?

you sample data has ordered, so we no need to worry about the result...

i think we can use ORDERBY clause...but again...

Karthik, pick up a telephone directory sometime. Here's a hint or two:

DROP TABLE #t1

create table #t1 (name varchar(15))

insert into #t1

select 'Guna' union all

select 'Jonny' union all

select 'kamatchi' union all

select 'karthik'...

What do you want to know?

Why should it be any different to

select * from emp where name > 'Karthik'?

Hi Herman

Here's a few more kids to play with:

INSERT INTO #KIDS(ID, REQ_ID, NAme, Birth_DAte)

SELECT 1,1,'Harry', '20010101' UNION ALL

SELECT 2,1,'Betty', '20020101' UNION ALL

SELECT 3,2,'Hank', '19991111' UNION ALL

SELECT...