Browse By Tags

  • SSRS Date Parameters

    I am attempting to build a report for SSRS using Visual Studio. I have a query that is returning results, and the report is functioning perfectly. However, the end user decided they wanted a date range selector on this report. I have done this hundreds…
  • ErrorMessage: Input string was not in a correct format

    Hello, After I run a job it shows that all the inserts and updates were failed. Almost all the error message (which I could see in 'Transaction Errors') say that 'Input string was not in a correct format'. I want to know how can I get to know…
  • Getting current year, current month

    Hello, I am working on some query and part of the query needs me to select all the records from AR_CustomerSalesHistory table with FiscalYear equivalent to current year. I have tried these and some other combinations: SELECT * FROM AR_CustomerSalesHistory…