Recent content by Preetham16

Hello all I found the solution the correct syntax to convert the files in Batch is following ren M:\files\*.htm *.html Thank you people... Regards Pr

Sorry but it doesnt work ... Yes the files under the M drive and under the folder Files ... Should I try any other way ...??

I want to convert an Htm file to Html. I want to view the html file in Mobile device and I have 30 htm files which have to be converted to html every day. The Mobile device is not accepting the *.htm but accepting *.html. I tried using the following codes but none of them helped .... Ren...

Hello Gurus, Following Code is part of UNION QUERY ... after the UNION i would like to have the SUM of Value of the Columns ABSMG (quantity) VVBUM (Gross Sales) VVNUM (Net Sales) I am getting an error when I directly use a SUM FUNCTION at the following line of CODE as shown below...

I am trying to do the same thing .. but could not succeed so far could you please tell me the step how I can do that ..?

Hi gurus, How do I create totals for specific columns in a Union Query? Some code would be of Great appreciated

Hi gurus I have an Existing Query which joins couple of table and generates a Table VIEW. I need to write another query which should generate the SUMMARY 2 colums of that table (Quantities and Revenue)of that in the next row of the TABLE... Any inputs are highly appreciated. Cheers Pr

I still have the problem in my Select it says it cannot convert the VARCHAR to NUMERIC where as when I try directly on the SQL Server it works... PR

convert(numeric(10),a.partner(isnull(a.partner,'empty'))) as 'Partnernr', First of all the part (isnull(a.partner,'empty')) is checking if a.partner has any null values then isnull function is filling it with text called empty ... Then the Convert function is converting the Text to Numeric...

Hi Guru's SELECT convert(numeric(10),a.partner(isnull(a.partner,'0'))) as Partnernr from smokna1 as a I am getting the following Error message - Invalid Object name a.partner PR

Hi thanks for the replies I dont need DECEMALS...when I use INT its saying ILLEGAL EXPRESSION. PR

I would like to convert Varchar to Numeric and the following code am using in SQL but still am getting problems... cast(Cast(a.partner as char)as numeric(10)) as Partnernr regards.. PR

I have an interface in which I write SQL (Select statements) and generates an access table... The data is being filled properly in the table but after writing around 550 records then I get an Alert ": ERROR CODE 3001 INVALID ARGUMENT. " By going on clicking the alert box the DATA is getting...

Solved it .. Thanx

Dear Gurus I have a subreport which retrieves the Summary of the main report. The heading of the MAINREPORT is repeated in the SUMMARY section if the Summary is more than 1 page I see the heading of the MAINREPORT how do I omit the HEADING in the SUMMARY REPORT. Thanq BVK