Then try this as a script first:

DECLARE @Path NVARCHAR(500);

SET @Path = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2K8R2\MSSQL\Backup\Restores'

--Backs up version DB that was just upgraded. This should always be one version back

BACKUP...

SELECT DCOD, DName

FROM

(SELECT DISTINCT DCOD, DName, DDate FROM SomeTable) AS drv

GROUP BY

DCOD, DName

HAVING

COUNT(*) > 1

The drv above is the alias for the derived table in the outer FROM clause.

Next question, from SSMS can query the test database and verify the data to the same query in production?

Sean Lange (4/17/2012)

---

capn.hector (4/17/2012)

---

Sean Lange (4/17/2012)

---

hbtkp (4/17/2012)

---

OK ,IF I CANNOT HEN how can i store my logic which include execute sp and returns 1 value

i need to call this value...

Evil Kraig F (4/17/2012)

---

Relax, we save...

What's wrong with doing it this way?

BACKUP DATABASE [Current_LastNAInitialVersion]

TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2K8R2\MSSQL\Backup\Restores\Current_LastNAInitialVersion.bak'

WITH NOFORMAT,

INIT,

NAME = N'Current_LastNAInitialVersion-Full Database...

After a quick look, I saw a duplicate. But without know which columns are indexes or just included columns, not really sure otherwise.

I take it you ran this in a query window in SSMS. When it finished, what message(s) did you see?

Once more with...

Help us help you, read the article Forum Etiquette:...

SQLKnowItAll (4/17/2012)

---

sqlfriends (4/17/2012)

---

SQLKnowItAll (4/17/2012)

---

No, look:

ALTER TABLE [dbo].[batSchoolRangeProgramResult] WITH CHECK ADD CONSTRAINT [FK_batSchoolRangeProgramResult_appSchoolRangeProgramSnapshot] FOREIGN KEY([ProcessID], [SchoolYear], [SchoolID], [RangeCd], [ProgramID])

REFERENCES [dbo].[appSchoolRangeProgramSnapshot] ([ProcessID], [SchoolYear], [SchoolID], [RangeCd], [ProgramID])

So the constraint is on...

Lynn Pettis (4/17/2012)

---

hbtkp (4/17/2012)

---

ok. i will go through book.

right now i need 1 solution

i have created 1 sp, and in that i am calling another sp.

now

this sp returns 1...

hbtkp (4/17/2012)

---

ok. i will go through book.

right now i need 1 solution

i have created 1 sp, and in that i am calling another sp.

now

this sp returns 1 float value

that...

hbtkp (4/17/2012)

---

ok. i will go through book.

right now i need 1 solution

i have created 1 sp, and in that i am calling another sp.

now

this sp returns 1 float value

that...

Some examples where it doesn't apear that everything is duplicated would work nicely. In your OP it appears that the 8:300 entries are all the same in both tables.