Please check if the following thread helps

http://blogs.msdn.com/brada/archive/2005/06/24/432209.aspx

Why don't you trying restarting the SQL Server Service unless you are running some realtime production databases on the server.

You may want to create a temp table and dump the data into that table and delete the duplicate rows using a cursor and fetch the data and display it...

Sarvesh, I am sure you are using SQL Server 2000 as your database. The syntax is not supported in SQL Server 2000.

As is said and experienced, dynamic sql is not recommended, however for your question the dynamic sql can accomplish the task.

DECLARE @counter INT, @cost CHAR(6)

DECLARE @sql VARCHAR(2000) -- you can...

How would this solution work??

CREATE VIEW MyView

AS

SELECT  ID,

 AmtType AS Type,

 Amt_1_desc AS [Amt Desc],

 Amt_1 AS Amt

FROM

 MyTable

UNION ALL

SELECT  ID,

 AmtType AS Type,

 Amt_2_desc AS [Amt Desc],

 Amt_2 AS Amt

FROM

 MyTable

UNION ALL

SELECT  ID,

 AmtType AS Type,

 Amt_3_desc AS [Amt Desc],

 Amt_3 AS Amt

FROM

 MyTable

GO

SELECT *...

CREATE TABLE #Output (ID INT NOT NULL IDENTITY(1,1), NAME VARCHAR(50))

INSERT INTO #Output

SELECT Name FROM Table1

UNION ALL

SELECT Name FROM Table2

SELECT * FROM #Output

DROP TABLE #Output

Your question is little ambiguous, it would make it more clear if you could just post with some sample data as to how it is currently stored in the table...

Hi John, thanks for setting the things straight. It is as simple as what you said

SELECT

a.CompanyID,

a

.CompanyName