Glad to have helped!

Forgot to tell you that if you go to BOL (books online) & look up "pages and extents" you should find a fairly comprehensive explanation...here's an extract...

The fundamental unit of...

Do you have several varchar columns ?! What is the length of the varchar columns - the sum of all the columns should not exceed 8060!! Better yet - could...

Also - I've personally not used the IIF function in Sql Server, but try changing your syntax to:

SELECT clinno, ssn, dateof, 'IIF(blue > 3, "Depressed", "OK")' AS depressed

FROM [dbo].[ORYX_PPS]

Jim - I'm not sure why you said you cannot use case...when statements ?!?! Any particular reason....?!

Your query should work with:

SELECT clinno, ssn, dateof, Depressed = case when blue >...

SELECT * FROM INFORMATION_SCHEMA.VIEW_COLUMN_USAGE WHERE COLUMN_NAME = 'custname'

AND TABLE_NAME IN ('svc00200', 'svc30200')

that's right 5000 posts...oops, I mean - remi....oops, I mean one who doesn't give back NAMES given on loan....OOPS, I mean RGR'us....

select @@servername - what you want ?!?!

I'm sure something could be done with this given TIME which I unfortunately do not have....

The name in syscolumns actually stores the "alias" not the original column name...so..

select * from...

can't really find anything except to "eyeball" it using:

SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'vwFormsUsage'

..doesn't help I know..well, if anyone can find it remi can so we'll just...

remi - I think the requirement is not just to get the columns used but the alias used against each...there must be a way to get this information - nothing...

Begad me lad - belay that addled thinkin' - ye be talkin' bilge - me ain't got no more skoolin' than me Cap'n - 'tis the grog in me talkin'...

Ahoy y'self - is't me ye be talkin' to - ?!?! or that thar lad from down under ?!?!

Nicholas - here're links to articles on upsizing - don't know if any of them address datetime datatypes in particular - hopefully at least one will...

migrating

upsizing 1

upsizing...

Notice Farrell - how he carefully (& cleverly) skirts the issue of hiring... maybe some beurre is required to pave the way...?!?!