Because of this my main table is locking; i have to rollback explicitly if it fails.

for this SET XACT_ABORT ON; will work?

thank you, it worked

How to rewrite as single statement with out variable?

I tried this way

@[User::IsActive] == "0" ? "@[User::Path]+ "\\" + "Test_"+(DT_WSTR,4)YEAR(GETDATE()) + RIGHT("0" + (DT_WSTR,2)MONTH(GETDATE()), 2) + RIGHT("0" + (DT_WSTR,2)DAY( GETDATE()), 2)+ RIGHT("0" + (DT_WSTR,2)DATEPART("hh", GETDATE()), 2)+".txt"" ? "@[User::Path]+ "\\"...

Hello David, Instead of calling from procedure, can we handle in SSIS package using script component?  with out casting original columns from the table?

thank you for the reply

TY for the reply, i am trying to select phone number and phone type from these two tables based on employee id and insert into dept table

Insert into...

i am talking about using temp table, and by using rank function can we achieve this?

Example  -

ReportID     path
101           /DEV/Reports/DEV/Reports/FOlderName/ReportName1
210           /DEV/Reports/DEV/Reports/FOlderName/ReportName2
303            /DEV/Reports/DEV/Reports/FOlderName/ReportName3
404            /DEV/Reports/DEV/Reports/FOlderName/ReportName4

Like this i have total 70 reports that have incorrect path
I need to update...

This procedure is used for asp.net front end.
In web page Based on the selection of Employee id's .. those id's should pass to this stored procedure.

In the...

select weekdes from dbo.FYear is the query

I want this column data to be in both start and end variables?

when i execute stored procedure same data should...

Its showing error -

Parse error at line: 1, column: 28: Incorrect syntax near '='.

How to tweak this statement - using Round

CAST((FLOOR((E.TotalAmount / COUNT(EE.ID) OVER (PARTITION BY E.ID)) * 100)) / 100 AS decimal(12,2)) AS Employee

floor will round always down so wants to modify with normal math function

for example - 1.229 will round up to 1.23 .

table -1 - Expenses

ID     total Amount (decimal(26,9),null)       EmpID

123            112.19                           84746788

table - 2 - EmployeeExpenses

ID             EMpID               TotalEmployees

123           84746788             22.47
123           89246532             22.43
123           88456788             22.43
123           89346788             22.43
123           87536788            ...