Try it

Create Function dbo.Fun_Proc_Test1(@id1 int) Returns varchar(30)

As

Begin

Declare @res varchar(30)

--Set @res = (Select * From OpenQuery(ABHI, N'Declare @result varchar(30) Exec Abhi.Test.dbo.convert2Lower @id = ' + Cast(@id1 As Varchar(5)) + ''', ...

Are you looking something like this?

declare @tblMain table (NO int, NAME varchar(100))

insert into @tblMain (NO, NAME) values

(1, 'Samsung Corporation'),

(2, 'Samsung Electro-Mechanics Co., Ltd.'),

(3, 'Samsung NEC Mobile Display Co., Ltd'),

(4,...

Cast/Convert the output. Try

Declare @i int = 10

Select Cast(@i as varchar(10))

Merge should help u...

MERGE INTO TABLE_NAME USING table_reference ON (condition)

WHEN MATCHED THEN

UPDATE SET column1 = value1 [, column2 = value2 ...]

WHEN...

Its continuation to my previous reply 🙂

Small change in update

--and the twist here is i need to update these 2 rows (1 and 4) with let's say RecordToCall = 1

Update

App

Set

App.RecordToCall = 1

From

Appointments App,

(

Select

RecNum,

RANK() Over...

check it...

Set NoCount On

Create table Appointments (

RecNum int,

Patient_ID int,

Patient_FirstName varchar(25),

Emp_ID int,

Emp_FirstName varchar(25),

App_Datetime datetime,

RecordToCall bit )

Insert into Appointments (RecNum, Patient_ID, Patient_FirstName, Emp_ID, Emp_FirstName, App_Datetime) Values

(1, 1234, 'John', 9876, 'Adam', '5/12/2012 9:00...

Otherwise, use ModifiedBy Column in the parent table and refer it in the trigger.

Let us know the expected o/p

Let me know the intended result of your query...

Check the read and write %age on the tables. If the table is queried ones in a year, then there is no pointing in having indexes for such tables. Bank...

Try this

Select

dq_src_id

dq_org_dist_id,

dq_rec_seq_nbr,

dq_status_cd,

dq_prev_status_cd,

dq_curr_status,

dq_rec_eff_dt,

dq_rec_upd_user,

rank() over (partition by dq_org_dist_id Order By dq_src_id Desc) as Rank

From

tmp_dist

Order By

dq_org_dist_id

Try it...

Set ANSI_NULLS ON

Set QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[AppInsert] (

@User int

,@ID int

,@price money )

AS

Begin

IF EXISTS (SELECT Null FROM dbo.PriceTest WHERE User = @User AND ID = @ID)

UPDATE dbo.PriceTest SET Price...

Try this

Create Table #tmpExecution (Id int Identity, dtStart Datetime, dtEnd Datetime)

Declare @dtStart DateTime, @dtEnd DateTime

While (1=1)

Begin

Select @dtStart = GETDATE()

Execute 'Stored Procedure'

Select @dtEnd = GETDATE()

Insert into #tmpExecution (dtStart, dtEnd) Values (@dtStart,...

Not able to find simpler than this:(