Bhuvnesh (11/30/2012)

---

1. take create temp table approach instead of select into approach coz it also lock the main base table and i dnt think here you require...

This is the syntax of the table

----------------------------------------------------------------------

USE [CONCENTRIX_DM]

GO

/****** Object: Table [dbo].[tblCob] Script Date: 11/30/2012 23:20:16 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tblCob](

[ID] [dbo].[udtID] IDENTITY(1,1) NOT NULL,

[LocationID]...

Hi,

What kind of data should I post which would be helpful?

Thanks