That's the way I originally wrote it.  That gave me an error on a different line.  I guess that SQL Server alone doesn't support anything more than just the creation...

Look to local.  We had a drive go out on an old Dell server and we didn't order another spare from the last time a drive went out. 

Dell still...

PW - the err column is a varchar(100).  I haven't used varchar that much, so I just had the RTRIM on there for safety.  Would LIKE '[a-z,0-9]%' be the functional...

I have tried to convert it into a query that's all joins instead of the subquerys, but I didn't see a performance increase.  It was close, but still a couple...

Just a note, but the exc and sch tables are being modified by other users, so I'm not sure if a derived table would help. 

I have tried to setup...

Alright, you asked for it . .

select distinct top 100 percent k.off_cod, k.ssn, d2.fullpart, d2.maxhours, d.mid_ini, rtrim(d.fir_nam) as fir_nam, rtrim(d.las_nam) as las_nam, 

                          isnull((select distinct...

That worked thanks.

I didn't see the solid title.  The two shades of blue pretty much hide the text if you aren't looking for it.  I didn't see any reference to rock in...

Maybe I am just missing something, but I don't get the picture of the rock with the caption 'I ain't as stupid as I look.'  What's the rock suppose to...

I know I am going to offend someone out there, but motorsports are not sports.  Yes, they are dangerous. If you were peddling the car it would be a sport,...

I want to buy a cat door that transports my wife's cat to another dimension, never to return. 

I fixed it.  Somehow the compatibility level got set to 65 and my recovery model got changed also.  Not sure how this happened and I can't find anything in the...

The game's name was Operation, not Emergency.

My first big one was where I took a joystick apart and conencted it to an 'Emergency' game.  You know, the game where it's suppose to be an operating table...

Is '5 spaces'>'' ?

Can you store '5 spaces' in a varchar, or will it just reduce it to ''?

I am contenplating converting the column to varchar to save space, but...