select

ID = row_number() over (partition by TABLENAME order by COLNAME),

TABLENAME,

COLNAME

from

#temp;

Snargables (3/7/2013)

---

NOTICE THE DESIRED OUTPUT ON THE BOTTOM.

SELECT 'table1' TABLENAME

,'col1' COLNAME

INTO #temp

UNION ALL

SELECT 'table1'

,'col2'

UNION ALL

SELECT 'table1'

,'col3'

UNION ALL

SELECT 'table2'

,'col1'

UNION ALL

SELECT 'table2'

,'col2'

UNION ALL

SELECT 'table3'

,'col1'

SELECT *

FROM...

ScottPletcher (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

ScottPletcher (3/7/2013)

---

Sorry, not to rain on the parade, but to me now is not the time to celebrate.

Getting the job is good, but it's just the start....

Sean Lange (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

wolfkillj (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

wolfkillj (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

jcrawf02 (3/7/2013)

---

You're absolutely right, the players should pay attention to what the ref is calling, not what the rules say,...

wolfkillj (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

wolfkillj (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

jcrawf02 (3/7/2013)

---

You're absolutely right, the players should pay attention to what the ref is calling, not what the rules say, because then they know...

wolfkillj (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

jcrawf02 (3/7/2013)

---

You're absolutely right, the players should pay attention to what the ref is calling, not what the rules say, because then they know what they can...

A SQL User CAL grants access for the user it is assigned to access all SQL Servers of the approriate version (and lower). To be absolutely sure, contact your...

Not...

And then again ...............

As a stored proc:

create procedure dbo.CopySerial(

@pSourceSerNum varchar(36), -- or whatever data type it is

@pTargetSerNum varchar(36) -- again change to match your...

harleen.suri (3/7/2013)

---

Thanks for the quick response Lynn. I already have a table called tblConfig, I think I need a stored procedure or some sort of a cursor which will copy...

Have you tried running the alter while in the database you are changing the collation?

Now, if this is a complex query what would the OP think of some of the really complex ones we have helped solve.

Stefan Krzywicki (3/7/2013)

---

wolfkillj (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

Sean Lange (3/7/2013)

---

Lynn Pettis (3/6/2013)

---

Several years ago my oldest daughter's JV soccer coach once confieded "I knew we were in trouble when half the team...

Start with this:

create table #Serials (

SerNum varchar(36),

ParamNum int,

ParamValue varchar(32),

Lock int,

Id...