If so...

could you please let me know the options to choose while i install the sql management studio without installing server.

Also, please note that i am intendint to connect to...

Oh! that is going to be fine as the field is percentage and logically it itself defining the rule.

so it will never be 101 percent or 101 per 100 as...

Thanks....

i should have used LTRIM without writing it here 🙂

DECLARE @columnx FLOAT, @columny nvarchar(2)

SELECT @columnx = 0.05, @columny = 'A'

SELECT @columny + STR(@columnx*100, 6,2) + '%'

displays A 5.00% which is having 2 spaces in between...

i am sorry, did not understand what BOL is?

could you please let me know the url?

Thanks for the reply Ramesh....

However, i would like to add that there are two columns which will required here. First is used for the sql statements and the second one...

After extracting the list of queries, where do i store them?

Also, there are few queries, which are parameterized.

how do i make the whole thing going?

i am well aware of what SSIS can do.

But i wanted to direct two variables to an excel sheet.

After converting, i did not get any error while building.

However, while running itgot the following error:

Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "sp_OracleInterface_InvoiceNoTemp '12/12/2008','31/12/2008 14:14:33'"...

Added to the last post, how do i open expression builder for a variable.

i have not ellipsis or any button for the Expression field for the variable.

still it did not work

------------------------------

Nonfatal errors occurred while saving the package:

Error at Package: The data types "DT_WSTR" and "DT_DATE" are incompatible for binary operator "+". The operand types could not...

Thanks for the reply...

still it does not seem to work.

first i have defined a package level varibale StartDate of value type datetime

then i created another variable sqlstring for holding the...

Many Thanks.............

Thanks...

well, i tried to find out all the styles

by using below code:

declare @style int

set @style=1

while @style <= 500

begin

print CONVERT(CHAR(100),GETDATE(),@style)

set @style=@style + 1

end

however i did not get 20081223 as...