opc.three (7/27/2011)

---

Upgrade Advisor is a good place to start. Are you doing an in-place upgrade? Will you have new servers? Make sure you have good backups whatever you do. Here...

David Portas (7/22/2011)

---

Microsoft is just following the SQL standard....

PaulB-TheOneAndOnly (7/16/2011)

If you are not planning to enforce Referential Integrity on the particular table then PK is not needed.

By the way, not only SQL Server allows for it - that's...

Sean Lange (7/15/2011)

---

This really won't let you get an accurate count. It will work until you delete a record. If you want an arbitrary number as your primary key use...

GilaMonster (7/15/2011)

---

The one case that comes to mind is a staging table. If I'm importing data from some other system and I know that it's got data integrity issues, I'll...

Jayanth_Kurup (7/15/2011)

---

Enforcing primary key on a table is purely a design decision , while sql doesn't force it; it allows suitable substitutes in columns such as identity columns , timestamps...

I just want to know why does SQL Server allow duplicate value. What is the

purpose behind it ?

duplicate value may create some issues.

duplicacy issue .

update #temp

set #temp.Quantity_mc = a.Total ...

subrata.bauri-1051938 (6/29/2011)

---

Lowell (6/29/2011)

---

TOP 1 isn't useful without an ORDER BY.

if you run this:

SELECT * FROM table

where psp_item_no = 'DRR07DFAB0034'

AND psp_ps_no = 16

how many rows show up? if there...

Lowell (6/29/2011)

---

TOP 1 isn't useful without an ORDER BY.

if you run this:

SELECT * FROM table

where psp_item_no = 'DRR07DFAB0034'

AND psp_ps_no = 16

how many rows show up? if there is...

It may not be the 1st row. Ok.

update #temp

set #temp.Quantity_mc = a.Total

from #temp Inner...

ColdCoffee (6/9/2011)

---

something like:

select pmd.psp_item_no,pmd.psp_item_var,sum(psp_qty_prpnl) as Total

from pmddb..pmd_mpsp_ps_postn pmd

--== added freshly

...

Thanks for reply..

Plz look my code below :

update #temp ...