Thank you, Jeff.

scdecade: that worked

select format(cast(@qtramt1 as bigint), 'd14');

Thank you

I am trying to create a row in a table that is created as: CREATE TABLE tax_table ( Data char(275)).  Within this table the "Data" consist of 4 fields that are...

@qtramt1 = 94500  This just a sample.  It is defined as @qtramt1 numeric(11,0).  But I need it to expand to 14 positions and zero fill.  This is just one of...

I would like to express my thanks to all. The answer is that there was another criteria where the class status was incorrectly being checked. I do not...

I am trying to use the SECTION_MASTER.YR_CDE (char(4)) to compare to REG_CONFIG.CUR_YR_DFLT (char(4)) minus 1. Then doing it for past year 2 and 3 and etc. back for 6...

Yes, I guess. I have seen this command several times, but do not totally know how it works. I have created a table on the database and I...