Lee Hopkins (6/23/2014)

---

just the query to get my counts back by city.

my problem is i the record i need to keep could be say row 5 of a partition (of...

Rog Saber (6/23/2014)

---

Lynn Pettis (6/23/2014)

---

Not the most efficient way to do it, but I'm sure someone will come along with a better solution (or I may given more time):

with base...

So something like this:

/*

1 5 City A Delete

3 6 City B Delete

1 7 City C Delete

1 8 City E Keep

2 8 City E Delete

3 8 City E Delete

1 9 City...

Do you mean to delete from the result set or the table?

Maybe something like this:

create table dbo.Emp(

EmpId int identity(1,1),

EmpName varchar(32)

);

create table dbo.Audit(

AuditId int identity(1,1),

...

Not the most efficient way to do it, but I'm sure someone will come along with a better solution (or I may given more time):

with base as (

select

...

Jeff Moden (6/23/2014)

---

pwalter83 (6/23/2014)

---

ChrisM@Work (6/23/2014)

---

pwalter83 (6/23/2014)

---

ChrisM@Work (6/23/2014)

---

Paul, you have two threads open which cover the same problem. Can I suggest you choose one of them and close the other? You...

I don't have a script I can provide but you may want to look at PowerShell for this.

Eirikur Eiriksson (6/21/2014)

---

Lynn Pettis (6/21/2014)

---

Here is how I am importing an XML file into an XML variable for processing. The key is the OPENROWSET BULK option. Hope this...

I've used synonyms before as well, should have thought of it myself. But, it was a good exercise in learning to swap partitions since I hadn't done it before.

thomashohner (6/21/2014)

---

@Lynn just let me know when your ready for the info, I know of two companies right now that are growing fast and both use SQL server. I'm just...

thomashohner (6/21/2014)

---

@Lynn,the company I will be working for is getting overwhelmed right now. Thats why they decided to go ahead and hire me without the specific contract for a paticular...

Here is how I am importing an XML file into an XML variable for processing. The key is the OPENROWSET BULK option. Hope this helps some.

declare @Filename nvarchar(256),

...

Congratulations! Hoping I can find a position working from home when I redeploy from Afghanistan. Would be awesome.

Using TheSQLGuru's idea, create two tables in your database that mirror each of the tables including indexes you need to update once a day. One table can be labeled...