Could you please advise...

I don't think we will see J.C. back to this discussion. He is out training people and writing books to add to his signature

In my previous post I've tried to...

Sorry, Joe, but your answers are not only inappropriate, but also will introduce bad limitations in design, I have very strong words to say about your advices, but I will...

create one!

try this one:

select top 1000000 1 as a

into #t

from sys.columns c1

cross join sys.columns c2

cross join sys.columns c3

cross join sys.columns c4

harri.reddy (9/13/2012)

---

hi,

i have 1 table which has millions of rows, i am doing select * from tablename

and select count(*) from tablename

does this both take same time or different,if different then...

CELKO (9/13/2012)

---

It is accurate. We have derived tables and CTEs which...

May be here you could finally suggest a good...

ScottPletcher (9/13/2012)

---

Eugene Elutin (9/12/2012)

---

Greg Snidow (9/12/2012)

---

Jeff Moden (9/12/2012)

---

It's even more annoying when you need it and...

scogeb (9/13/2012)

---

Eugene Elutin (9/13/2012)

---

Who gave you such impression or where did you take it from?

Quite often splitting tasks using temp tables will not only significantly boost performance of complicated...

...

Yep, that works too and I get accurate results in 2 seconds or so. I was under the impression it's best to avoid temp tables if you can though....

1. How many groups you are going to compare at once?

2. If the answer to the first question is two, will you provide GroupId's for groups to compare into the...

Can you try this:

SELECT column1,'99' [a],left(column2,2) , max(column3) [c], 'Yes' [d], 'Test' [e]

,ltrim(rtrim(column1))+ltrim(rtrim(left(column2,2))) as test

INTO #pre1

FROM...

OK, I've missed the "change of concept" from OP.

However, I still advice to use dynamic SQL. Why? I kind of think that it will perform better here...

Looks like he is not working in the "office". He is a TEACHER!

I just can only image that his students love him...

aaron.reese (9/13/2012)

---

consitency is the important thing here.

I prefer the PK to be called ID.

TABLE.ID refers to this tables PK

TABLE.SOMETABLE_ID refers to the related tables PK and infers a single field...