Use the DMVs.

master.sys.databases

<database>.sys.tables

<database>.sys.columns

I think you're over-thinking it SQL-Dude.

Think more like this:

CREATE TABLE Bldg (BldgName VARCHAR(20) NOT NULL CONSTRAINT PK_Bldg PRIMARY KEY CLUSTERED)

-- Floor is a SQL Function and keyword

CREATE TABLE Floors

(FloorName...

The other option is to force the datatype on the select before it hits the select into.

IE: SELECT CONVERT( varchar(9), xyz.fLeft_Pad('0', Str(123456789),9))

At that point though you might as well define...

Hey Dougie,

Don't feel bad about this code, that's some signficantly nasty iterations they've got going there. Have you been having performance problems with this code as well?

Can you script...

I'd personally approach it via the second method, at least for the primary build, but I wouldn't associate room to floor and building, I'd merely associate it to a floor...

Dev (11/28/2011)

---

Jeff Moden (11/24/2011)

---

Although that's the general concensus,...

You're correct, Jeff, I'm just concerned about using partitioning...

Sorry it took a bit to get back to this, pesky Thanksgiving...

Alexander Suprun (11/24/2011)

---

Hi Craig,

I've played around with your scripts and here are my thoughts and findings:

I see why you've...

Kiara (11/29/2011)

---

Evil Kraig F (11/28/2011)

---

Title:...

f.panci (11/29/2011)

---

The program has worked correct for a period of 4 years and the problem has been caused by un proper shutdown because of fail of electricity. This is all...

As mentioned above, it's the same problem. , + CR to CR or , to blank and leaving the CR alone leaves the...

At first glance, you'll need to use the directory or filesystem commands in a script object to read the attributes of the file, edit a local SSIS variable used as...

derekr 43208 (11/28/2011)

---

If the Master DB is corrupt, you will have to rebuild it - this is done with the installation media.

Something like this

start /wait <CD or DVD Drive>\setup.exe /qn

INSTANCENAME=<InstanceName>...

Faye Fouladi (11/28/2011)

---

Case

when bv.SpotDescription <> 'Spot Description' Then

pf.SpotDescription = bv.SpotDescription

End,

instead of the line that says:

pf.SpotDescription = bv.SpotDescription

I keep getting an error: Incorrect syntax...

You want it to look like:

insert into #t1(col1, col2, col3, col4, col5)

Select

col1, col2, col3, col4, col5

from

R1

where

R1.col1 > 0

and R1.col5 = 1

and R1.col1...