jgangemi (2/10/2009)

---

I encountered a similiar problem one rainy july evening while I was mercilessy beating my pet dog Jenkins. I found the best result was to physically threaten my neighbors...

And if you don't need those constraints and indexes for the temporary work, why go through the process of creating them when the SELECT INTO works just fine.

Question stated "Now I need a copy of this table with an identity column for some temporary work." This is the phrase that pointed me to select "Use an...

I find if you don't read too much into these questions that they are usually fairly easy to answer. Unfortunately it seems people add a lot of contraints and...

Each has its place, neither is actually better than the other for most applications. You get into the niche areas, that no longer becomes the true. There may...

Alright, seeing you laugh makes it all worthwhile! :w00t:

Sergiy (2/9/2009)

---

Actually, the question was not for you.

🙂

You may realize that if you look at...

Actually, Sergiy, I have no idea. Since Adi posted what appears to be a working solution, I have tried yours nor worked...

The problem we are having is trying to decode your logic. It would help if you could clarify the logic more like the following:

(This is not SQL code, but...

Looking back through the posts, it appears tha Adi has already provided a working solution, so I won't look into this further at this time.

Judy (2/9/2009)

---

arun.sas (2/9/2009)

---

Tray this

simple

Create table #t(rating int,bookid int)

insert into #t

select 97, 201

union all

select 96,100

union all

select 95,300

union all

select 50,100

union all

select 10,201

union all

select 30,300

select a.rating,b.bookid from #t a, #t b

where...

Olga B (2/9/2009)

---

Great article. The best thing about the suggested approach is that if the poster takes the time to define the problem and consider the test data and the...

Eat (2/9/2009)

---

We are running into a similar issue.

When attempting to login through a Windows Group, I receive the "Cannot open user default database. Login failed." message. Default...

It would help if you upload the actual execution plan.

At least I don't have to rely on SQL Server for those, my wife is a Massage Therapist.