You seem to be trying to turn columns into rows. Will one of the solutions below work for you?

declare @sample table ([product_id_1] int,

[scan_time__sec] int,

[focal_spot_mm] int,...

Is that why my @@ARID value keeps changing?

Who are you?

Who sent you?

Why are you following us?

😛

As Grant would tell you, it's hard to know for sure without looking at an execution plan. Given an index on [createTimestamp ], the optimizer may be smart enough...

Second Steve's sentiments about changing the structure of the table. Whether it's called an EAV or a MUCK, that design has been "invented" again and again over...

Whups...

Here we go, Jeff:

It is the CROSSTAB of UNPIVOTS

Is this what we're looking for?

declare @sample table (ID int identity(1,1), Column1 varchar(10), column2 varchar(10), column3 varchar(10))

insert into @sample

select 'row11', 'row12',...

It would also be nice to know the volumes in each of the tables involved. What would really help would be an execution plan for this query,...

This takes me back to childhood....

Q: Why did the elephant climb the tree?

A: To play with his friend, the rhino.

Q: Why did the elephant sit...

The good news is that when you do parameterized dynamic SQL, it can take advantages of existing indexes and views, and even cache a query plan for future use by...

Perhaps I'm not explaining clearly enough.

The comparison to the customer ID is hard coded in the WHERE clause. It has nothing to do...

You're welcome Vishal. But looking at your "working" example, what you are doing isn't really dynamic SQL at all. You are assigning a...

Agreed. Parameterized dynamic SQL using sp_executesql not only prevents SQL injection attacks, it also provides for execution plan caching.

You can't "set a column name" without using dynamic SQL. You can use a CASE expression to choose between two column VALUES, but this could very well cause...

GilaMonster (10/4/2010)

---

CirquedeSQLeil (10/4/2010)

---

GilaMonster (10/4/2010)

---

Craig Farrell (10/4/2010)

---

Alvin Ramard (10/4/2010)

---

GilaMonster (10/4/2010)

---

I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after...