Search results for query: *

We are using the pivot functionality in our query and that is why we doing the casting otherwise i get the following error: Disallowed implicit conversion from data type sql_variant to data type numeric, table 'pvt1', column '128'. Use the CONVERT function to run this query. i followed your...

The user has an option to enter the temperature in any format.If the user eneters the temp in centigrade or Farenheit there will be no conversion however if the user enters in kelvin then we convert it to degreeF and degreeC

float

Thanks for the link.I have a formula in one of my stored procedure /*Kelvin to Celcius conversion (C = K-273)*/ (CASE WHEN max(temp)IS NOT NULL THEN CAST(MAX(CAST(temp AS float) - 273) AS float) END) AS TempC. /*Kelvin to Fahrenheit conversion (F = (9/5) C + 32)*/ (CASE WHEN max(temp) IS...

can someone plase provide the formula to convert a temperature in Kelvin to Celcius and Fahrenheit. Thanks

can someone plase provide the formula to convert a temperature in Kelvin to Celcius and Fahrenheit. Thanks

Hi, We have a SSIS package that is set up to load Data into our warehouse.This Package loads data to the ware house and processes the cubes once the dataware house load is complete.However there have been recent scenarios where empty cubes has been processesed due to some issues in the data...

When I am trying to add dynamic parameters to my crystal report I get the follwoing error messge: "operation failed; You do not have edit right on: "dynamic cascading prompts". (MDS.DLL)" I logged in with my windows AD account. I am running Crystal reports 2008.The parameters are created in...

I have a Crystal Report that runs OK , but all the data columns are misplaced after the data has been exported into the Microsoft Excel (97-2003) Data-Only format.This report is exported from Infoview For ex Before Export Acc code Interval Cycle Start Date Reaction Yes ABC445 Cycle 8...

Is there a mechanism to disable Reschedule feature for a specific report in BOE? ….we have a report which is becoming problematic on database because users are rescheduling without carefully looking what other options were in the instance history. Thanks

Hi , I get the following error An error has occurred: Could not find the document". Previously it used to work fine. When the Infoview timesout , I am unable to restore the document. I get the following error when clicked on Restore "An error has occurred: Could not find the document." I...