This cannot be the correct forum for this. ...

Please repost in either the SQL 2008 forum or in the SQL Newbies forum.

No, you cannot generally variablize column names, Dynamic SQL is how to do this.

There are some limited ways around it for specific cases, using if statements or other high-level branch...

It should be in your Start Menu's Microsoft SQL Server 2008 (R2) folder, as "SQL Server Business Intelligence Development Studio". If you don't see it then you need to...

In Management Studio:

1. Expand the "Security" folder underneath your server.

2. Right-click on the "Logins" folder, select "New Login..."

3. In the New Login window, add your Windows Logon...

I assume that you meant me?

Well, I use them for three things:

1. Security Layer. Part...

AFAIK you have the same problem if you try to create a table from the Object Explorer/using the Table Designer. The GUI just doesn't seem to support Schemas very...

Fal (8/24/2012)

---

I need to deal with a critical issue, but unfortunately fixing it keeps getting bumped. I was wondering what metaphors Threadizens might have to describe just how low...

Here's a slightly better way to go than that horrific Cursor thing:

First create a scalar UDF like this:

/*

Returns a formatted string of all of the column...

stephen mehl (8/23/2012)

---

Hello --

Can CASE be used as follows?

CASE

WHEN expression is TRUE THEN

SQLstatement#1

ELSE

SQLstatement#2

END

Thanks for any help,

Larry...

Ah, I see. Never mind then. 🙂

Mark-101232 (8/23/2012)

---

RBarryYoung (8/23/2012)

---

Actually, Jeff and I...

This works for me:

create table #TableSize (database_name varchar(150),

id int,

table_schema varchar(150),

table_name varchar(150),

...

Well, you could try to use this procedure here[/url], instead. It will handle all of the DB switching and Dynamic SQL issues for you.

You could also try using this...

Actually, Jeff and I learned about...

Have you upgraded your Management Studio...