I generally define input parms like so:

cmd.Parameters.AddWithValue("@TariffCode", TariffCode);

And I don't specify the size of the parameter.

It doesn't work like that. Google "dynamic sql" and sp_executesql or look it up in BOL.

I don't understand why you need to craft a decimal this way. Why not just decide on the maximum precision and scale you need based on the expected data...

Try this:

SET @sql = 'SELECT * FROM ' + @TableName + ' Where prod_id=' + CAST(@prod_num AS varchar(10))

And the HTML is identical in all cases. It looks fine in both OL2003 and IE6. The only place the problem shows up is when I print it...

It is a printer problem. :blink:

There are six columns in the table. Column 4 should say "Carryover" and column 5 should say "Holiday Party". Instead #4 says...

Hey, I remember Earl Schieb from growing up in Chicago! His TV commercial had him doing a voice over of two guys who looked like very recent parolees taping...

Don't wanna surf the web, listen to music, take photos, buy lattes, or play games on my phone; just wanna talk.

If you didn't take into account wage differences, and you really wanted...

Sure, as soon as I get the GPS that I got for last Christmas installed and the firmware upgraded, I'll let you know. In the meantime, just go to...

Anarctica. You should move there immediately. 😛

karthikeyan, if you got all the articles in a pdf instead of visiting the site, you'd miss out on all the ads. 😉

How are you inserting the row into the table? If you're using a stored procedure I can't think of how you would trigger execution of the VB.NET code on...

I don't think you can blame government for forcing companies to offer health benefits. Unions began forcing health benefits in their contracts, governments picked them up for their employees....

Nicely done. Thanks.