Search results for query: *

Hi, I have one main stored procedure. It calls other 10 stored procedures by giving input parameters. Do I want to implement Begin Try/Begin catch in each sub procedures or in main proceudre only. Please suggest how to achieve? Appreciate your help. Regards, Bala

I have separate scripts for Creation of Tables, Stored Procedures, Views, Triggers in different .sql files. I have to execute thses scripts in batch in different servers and different databases without opening SSMS. All .sql files to be executed in single command. Please suggest how to achieve...

Hi, I have 50 Reports in SSRS 2005 currently in production server. My Client want to migrate to SSRS 2012. I migrated one RDL using BIDS. I am using list items inside Text Box in those Reports. The Problem is design and style of the Report changed in SSRS 2012. Borders are not coming correctly...

I have a table with 4 columns. EmpName PayDate WageType PayRate ABC 10/22/2014 Regular 10.20 XYZ 10/22/2014 Regular 09.30 ABC 10/23/2014 Regular 10.20 ABC 10/24/2014 Regular 11.50 ABC 10/25/2014 Regular 11.20 XYZ 10/25/2014 Regular...

Hi, I am using SSRS 2005. I want to convert decimal numbers to Hours and minutes. Say suppose, I am adding daily work hours and minutes and the total is 208.63. Here 208 hrs and 63 minutes. How to convert this to 209 hrs 03 minutes in SSRS. Any In-built function is there? or how to do using...

Hi, I am using SSRS 2005. I want to enable/disable or hide/view parameters based on another parameter selection. Say Suppose I have 5 parameters. User selects first value in first parameter I should show only Second parameter and hide remaining 3 parameters (Parameter 3,Parameter 4 &...