Are there any duplicates?

If not, you could simply use

ROW_NUMBER() OVER(ORDER BY Value) - 1

JenMidnightDBA (1/6/2011)

---

mister.magoo (1/6/2011)

---

The DATEPART function has a WEEK datepart that displays the...

christophe.bernard 47659 (1/6/2011)

---

Hi,

thanks you so much for your sample now i understand that we can add a relation between the table deleted and inserted ..

Sorry i'm a beginner and i...

Another advice: once you posted something, don't delete or replace it by a comment like you just did. Stick to what you posted. Deleting posts is not following forum...

You posted about an hour ago on the other thread.

I strongly recommend to lower...

deepikamm (1/6/2011)

---

thank u ..simple and clear explanation.

consider this,

Original query

update workmgmtplan with(rowlock) set IsWebPlannerTracked=1 where planid=@WMPID

update workmgmtplan with(rowlock) set IsWebPlannerTracked=1 where planid in

(select workmgmtplanid from workmgmtlinkedplans with(nolock) where linkedworkmgmtplanid=@WMPID)...

If you're using SS2K8 (as indicated by the forum selected), you could pass the parameter using a table variable. That would avoid the additional overhead caused by XML tags.

No, both are different. And the link you provided shows the difference...

That's not how auto-incrementing works.

Usually, auto-incrementing is used to create a unique number to refernce that in another table. If you renumber your values, you'd change the references.

Why do you...

Something like this (assuming you're using SS2K5 or above)?

DECLARE @xml XML

SELECT @xml='<Root>

<Data>

<Item ID="1" AdditionalInfo="Some info">

<SubItem ID="1">1</SubItem>

<SubItem ID="2">2</SubItem>

<SubItem ID="3">3</SubItem>

</Item>

<Item ID="2" AdditionalInfo="Some info">

<SubItem ID="1">1</SubItem>

<SubItem ID="2">2</SubItem>

</Item>

</Data>

</Root>'

SELECT

y.value('@ID[1]','INT') AS SubItemId,

y.value('.','INT') AS SubItemValue,

c.value('@ID[1]','INT') AS ItemId,

c.value('@AdditionalInfo[1]','varchar(30)') AS...

franck.maton (1/6/2011)

---

Thanks for fast reply !

If I use a job, I'll get a mail every day even if no DB was created, right ?

The purpose is to get a mail...

hoanglong88i (1/6/2011)

---

Oh, Lutz, you're master. So many things to learn, I'm taking time on them. By the way, how to get the exact time when executing a query (to compare...

To slightly change Henricos script to exclude tempdb:

SELECT name FROM sys.databases

WHERE create_date > (GETDATE() -1)

AND name <>'tempdb'

@ITJITS:

I first thought it was WayneS who replied due the avatar.

May I kindly ask you to change it?

Kinda confusing...

Spam. Reported. (Not because of the message. Because of the signature. ;-))