thomashohner (7/16/2013)

---

Micky you are one awsome dude! Worked like a charm:w00t: I had to get this list the old fashion way by hand comparing lists in excel and then...

First, welcome to the SSC forums. This is a great place to get help and for someone looking to grow their SQL skills.

Note the link in my signature line for...

Here's how you can do it without PowerShell. Note that, in the code below, I am only getting the information for the SQL Service Account. The steps will be similar...

No problem.

I would start here: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D

ARGH!!!! I just attempted to post a detailed response, got an error and lost what I wrote. Forgive any errors and typos:

First, SSRS is not designed for this kind of...

The best way to resolve deadlocks is adding the trace flag as Wolfgang mentioned. That said, when you are dealing with Replication I strongly suggest you become familiar with the...

It's best to have the most current Service pack; Service Pack 2 is the most recent service pack for SQL Server 2008 R2.

See this article for more details.

Compression is available, my bad. I did not see that you were on 2008 R2.

You are using Standard Edition. I don't believe that Compression is available in Standard Edition.

Here's the code to turn the XML code in #2 into a table...

DECLARE @Pt TABLE (x XML not null);

INSERT INTO @Pt

SELECT '<Movie><MovieName>ABCD</MovieName><Genre>Horror</Genre></Movie>

<Movie><MovieName>EFGH</MovieName><Genre>Sci-Fi</Genre></Movie>

<Movie><MovieName>IJKL</MovieName><Genre>Comedy</Genre></Movie>';

SELECT m.value('(MovieName/text())[1]', 'varchar(20)') AS Movie,

m.value('(Genre/text())[1]',...

Glad to help 🙂

HanShi mentioned local and global temp tables. You don't see this as often but a global temp table has two numbers signs in front of it like so: ##temptable.

To...

The COALESCE method for running totals is terribly slow. Working with the link that Sean posted, here is an example of how to accomplish this using the "Quirky Update" method....

Based on the information you provided this may be what you are looking for:

USE tempdb;

IF OBJECT_ID('tempdb..Customer') IS NOT NULL

DROP TABLE Customer;

IF OBJECT_ID('tempdb..CustomerDetails') IS NOT NULL

DROP TABLE CustomerDetails;

IF OBJECT_ID('tempdb..TargetActivity') IS NOT...