I am still confused.

{"Conversion failed when converting the nvarchar value 'ticketID 0' to data type int."}

I get an error of ticketID 0?

Grasshopper

Has posted the correct solution. Thanks again.

SOLVED

I solved it. It was because I was running it twice.

Thanks guys.

Excellent job guys. I appreciate your work.

i will take alook at this. I apprecaite your help.

looks ok to me.

1sprGetTicketByTicketID330484256P 1000002009-06-01 12:02:36.843000P 0402009-06-01 12:02:36.8430000000

Msg 2714, Level 16, State 3, Procedure sprGetTicketByTicketID, Line 60

There is already an object named 'sprGetTicketByTicketID' in the database.

But there is not. Something weird.

It should be INNER JOIN tbl_lookup_type_services ON tbl_services.ServiceID = tbl_lookup_type_services.ServiceID

INNER JOIN tbl_index_ticket_services ON tbl_services.ServiceID = tbl_index_ticket_services.ServiceID

INNER JOIN tbl_lookup_type_services ON tbl_services.ServiceID = tbl_lookup_type_services.ServiceID

Msg 207, Level 16, State 1, Procedure sprGetAffectedServicesByTicketID, Line 26

Invalid column name 'ServiceID'.

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].sprGetAffectedServicesByTicketID') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].sprGetAffectedServicesByTicketID

GO

CREATE PROCEDURE [dbo].[sprGetAffectedServicesByTicketID]

(

@TicketID int

)

AS

BEGIN

SELECT

...

This is awesome how come in query analyzer I get the cross join.