nice job!

I need to do an insert.

create your ID column as identity column :

but this column is not an idenity column

is there a way I can set it to...

is this ok?

ALTER TABLE tblServiceProvider DROP COLUMN FinancialContactPrefix

GO

ALTER TABLE tblServiceProvider DROP COLUMN FinancialContact

GO

ALTER TABLE tblServiceProvider DROP COLUMN FinancialPosition

GO

ALTER TABLE tblServiceProvider DROP COLUMN FinancialPhone

GO

ALTER TABLE tblServiceProvider DROP COLUMN FinancialExtension

GO

ALTER TABLE tblServiceProvider...

do you have a table structure for

coutries

states/provinces

cities

do you have a table structure for

coutries

states/provinces

cities

sprGetCompanySIMCustomFieldsByCompanyID 'IS NULL','IS NULL','IS NULL','IS NULL','IS NULL',1,500,'Company','ASC',368

sprGetCompanySIMCustomFieldsByCompanyID '','','','','',1,500,'Company','ASC',368

AND tbl_sim_custom_fields.Custom1 is null

will return me all the rows

Note in my table all the values for

Custom1=null

Custom2=null

Custom3=null

Custom4=null

Custom5=null

What should I...

Can you help me get started I would appreciate it.

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

DROP PROCEDURE [dbo].[sprGetCompanySIMCustomFieldsByNullFilter]

GO

CREATE PROCEDURE [dbo].[sprGetCompanySIMCustomFieldsByNullFilter]

@Custom1HasData bit,

@Custom2HasData...

IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_ticket_history_tbl_tickets]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_ticket_history]'))

ALTER TABLE [dbo].[tbl_ticket_history] DROP CONSTRAINT [FK_tbl_ticket_history_tbl_tickets]

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_ticket_history]')...

I forget to create a foreign key constraint.

When I am doing an update into tbl_tickets the primary PK must be the same as the primary key in the table tbl_tickets_history...

It fails 🙁

U are right breajk, but I still get the error

Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0,...

Is this what you mean?

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

DROP PROCEDURE [dbo].sprUpdateReOpenedTicket

GO

CREATE PROCEDURE [dbo].sprUpdateReOpenedTicket

(

@ticketID int = null,

@ticketType nvarchar(50) = null,

@ticketStatus nvarchar(50)...

You can you show me what you mean.

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

DROP PROCEDURE [dbo].sprUpdateReOpenedTicket

GO

CREATE PROCEDURE [dbo].sprUpdateReOpenedTicket

(

@ticketID int =...

I read the article. I am making sure other people will read it.

This is what I am getting:

The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.

Transaction count after EXECUTE indicates that...

The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.

Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION...