Sounds like you are trying to update a column that has a numeric datatype with text..

The Master contains all of the SQL system items ect:

http://msdn.microsoft.com/en-us/library/ms187837.aspx

A the term Staging DB is normally applied to Data Warehousing and it is the area where you clean and transform...

Or if you wanted to do it dynamically:

CREATE TABLE #BaseData(ClientNo INT, Code VARCHAR(3))

INSERT INTO #BaseData(ClientNo, Code)

VALUES

(123,'AAL')

,(1234,'AAC')

,(123,'AAC')

,(1234,'QPL')

DECLARE

@sql VARCHAR(MAX)

,@COLUMNS VARCHAR(MAX)

SET @COLUMNS =

STUFF(( SELECT ',' + QUOTENAME(Code) AS [text()] FROM...

This may be of help..

http://www.blackwasp.co.uk/SQLIsLeapYear.aspx

I dont want to create a table to hold and highlight the leap years, I'm assuming there must be a way to do it without the use of an extra...

Have you considered creating a calendar table and using this to identify the leap years?

/Tips Hat

Impressive!!

I'd be no good for anything after that!! :sick:

I've used those reports in the past and they really are first rate

Jared:

Agreed all around. So, when we needed to look up a balance on a current customer we could do that calculation on a small number of records from just that...

I did once when my Active Directory permissions were changed by accident and this filtered down to my SQL permissions. If you use AD worth looking into..

Andy

Hi Lowell

I'm interested in your thoughts...

Gosh. I certainly hope that ISN'T true. A non-normailzed database will cause you more grief than you can ever imagine. Rather, you should ensure the database is properly normalized and...

It's a little extra work, but I always try to add a new column 'in the right place' where applicable. I concede that it doesn't actually make any difference from...

If you use the GUI Right Click on the table > Design > Right Click on the area you want to insert > Insert Column

Hi

have you tried

WHERE

(CompanyID IN (1,2,3) OR CompanyID IS NULL)

AND (AreaID IN (1,2,3) OR AreaID IS NULL)

Andy