seems like your column EEO1Classification is actually a varchar even though it might contain what seems to be just integers....so you'll have to explicitly convert it to do the sum...

what would happen if your procedure received NULL for either of the two parameters? could it raise an error?

exec [sp_ETL_To_Rpt] @frmdt,@todt

since your trigger says it's also for DELETE, and you...

i use getdate() excluseively; like others havre said, it's been in my repitoir for years, and also because of that datatype where a timestamp is not really a timestamp, but...

ok, this example, based on your provided data seems to work for me;

i'm assuming the discount rates are added to the same table...but i hope it is obvious that a...

interesting wissam;

the excel spreadsheet you receive, does the start and end date apply only to the short term offer? so for one month some rate is slightly cheaper, but the...

i don't think that is true; SQL will simply use only the TCP/IP instead;...

it's they way a default constraint works...i think you are misunderstanding it.

a default constraint DOES NOT replace nulls with the default value...it puts the default value in if the column...

is the length of the fields with preceding zeros all the same? for example are the 6 characters? '000008'?

you can change the column to a varchar, and then update...

not directly, no.

each column has to be referenced in the update statement, but you can use the schema tables to generate the SQL statement for you.

you were a little loose...

here's another way to do the same thing: ColdCoffee thank you for the setup!:

DECLARE @PhoneNumbers TABLE

(

ID INT IDENTITY(1,1),

TEL1 BIGINT,

TEL2 BIGINT,

TEL3...

the technology already exists....

I know the feeling...you put a lot of hard work and time into designing the database objects, and you don't want anyone to look at them because they could infer...

another way is to connect via the Dedicated Administrative Connection (DAC)

a perfect example would be you removed builtin\administrators and then forgot the sa password...which was the only sysadmin on your...

I had a similar issue where a specific login i created for testing would show up first when i selected a server...so i'd have to change it over and over...

nice explanation, Craig;