DROP TABLE #Tablename

CREATE TABLE #Tablename (ID INT, [Data] text)

INSERT INTO #Tablename (ID, [Data])

SELECT 1, 'sdfjksdhfksdhkfhsdkfhksdhfksdhfksdhf<t2>net.rim.blackberry</t2><t3>1</t3><t4>sadfsfsdfdsf</t4><t5>asdasdasdsa</t5><t6>7.0.0</t6><t7>asdasdasdsa</t7><t8>asdasdasdas</t8><t9>asdasdasd;</t9></R>'

union all

SELECT 2, 'sdfjksdhfksdhkfhsdkfhksdhfksdhfksdhf<t2>net.rim.blackberry<t2><t3>1</t3><t4>sadfsfsdfdsf</t4><t5>asdasdasdsa</t5><t6>7.0.0</t6><t7>asdasdasdsa</t7><t8>asdasdasdas</t8><t9>asdasdasd;</t9></R>'

-- this will return all of the string following '<t2>'...

@Counter means different things in different places, Jim. Not easy to follow. Try this instead:

SELECT...

sushilb (10/3/2011)

---

In the if condition i check whether am i getting the exact thirteen previous days(13 row) if count is less than 13 then i again subtracting the missing rows...

Can you fully and accurately account for the missing days? Is it all sundays? Is it only sundays?

The accuracy of the solution provided to you will reflect the accuracy...

R.P.Rozema (8/21/2011)

---

I don't know how this will work out for IPV6 addresses, but based on the idea of taking the bytes from the ip numbers and converting these into one...

Extend the links table, which would be better designed normalised like this:

GroupName Name

North_South North

North_South South

Something similar: a data feed to a warehouse was comparing the 10M row DW orders table to the 10M row OLTP orders table then aggregating to obtain the most recent...

Don't you know Wayne - fashion comes and goes. Hotpants again this summer...

Brandie Tarvin (5/24/2011)

---

Stefan Krzywicki (5/24/2011)

---

LutzM (5/23/2011)

---

Regarding the specific situation: it might be better for the person in question to officially ask for support. Try to deal with the situation "undercover"...

A couple of possibilities here[/url].

Use a filtered unique index.

Edit - quote captured wrong post.

It can be easily done but the performance will be poor. Your best option is to rework the stored procedure (or an alternative version of it, retaining the original) so...

Ninja's_RGR'us (5/20/2011)

---

ChrisM@home (5/20/2011)

---

It's not as tough as it looks Ninja - it's an INSERT from a...

It's not as tough as it looks Ninja - it's an INSERT from a SELECT, OUTPUTting...

Look up the OUTPUT clause in Books Online.