I need to joing on service ID.

SELECT tbl_index_ticket_services.ServiceID, tbl_lookup_type_services.ID, tbl_lookup_type_services.ServiceType, tbl_index_ticket_services.DateAdded,

...

Hi there, I have a solution but if the entry is existing it just does an update. Canyou please help me out,

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER procedure [dbo].[sprInsertServiceTypeToTicket]

(

@ticketID int =...

I would love it if you guys could give me an hand.

CREATE PROCEDURE [dbo].[sprUpdateServiceTypeToTicket]

@indexTicketServiceID int = null,

@ticketID int = null,

@dateAdded datetime = null,

@agentAdded nvarchar(50) = null,

@dateCreated datetime = null,

@flagRemoved bit...

I would like to fix the stored procedure what needs to be fixed?

so if exist then do an update otherwise do an insert.