Thank You, I got it.

yes

Thanks I got it. Really appreciated your help

This one worked for me....Thanks

DECLARE @a INT

SET @a = ?

insert into dbo.test_delete_yes

select @a as value

This is the query I have written in the sql_statement of the Execute...

Man ....this is superb....it worked great, but I could not get the logic. Can you please explain? Anyways thanks for that

Man..this is superb.....it worked great. But whats the logic in this ?

It did not work. I need the formating but the underlying data should be as it is. If I use the query you suggested in the format tab, I am...

Thanks for the reply. I did try all the options in the the format tab, but all the options in the format tab will do rounding of the number to...

Actually I do not want on the DB side. I can explain it to you clearly. Here it goes - For example I have the data on DB side as...

I asked my Manager and he asked me to print blank (Nothing) instead of "-". Now the values that are exported to excel are comming up as numeric. My problem...

For example I have a column with Amount having values Null and 10.

I want to display hyphen in place of Null. When I export to excel it gives me an...