Excellent. When...

D-SQL (10/3/2012)

---

I have been going through the forums on how to read this graph. I was asked where does a certain query in the graph can be located and have...

Use an Identity column in the target table to get your numerics.

Then use a calculated column on a varchar field to apply that to the formatting you need in the...

Can you be a bit more explicit as to what dynamics you're intending here, and what exactly you've tried?

A configuration loads at the beginning of the run, and is set...

Hey Chi Chi,

I've done something similar to this, and Sean's misgivings notwithstanding I agree there are times workflow needs this information.

However, make sure that accounting has a way to go...

Transactions and SSIS are... painful at best. However, make sure that your connections that you're using in your transactions are set to reuse same connection (keep connection... something like...

Who's sending you...

Apologies Mark, I've been heavily tied up the last few days and didn't have time to really dig into the information and virus-scan the .zip. I'd hoped someone else...

Joy Smith San (9/27/2012)

---

Evil Kraig F (9/27/2012)

---

vandana_j79 (9/26/2012)

---

I have setup job which run ssis package. In this job i pick data from oracle server with link server. When i run...

L' Eomot Inversé (9/28/2012)

---

I don't see the difference in principle between using a spreadsheet, using good source control, configuration management, and version control software, or using an old fashioned T-card...

Websense block unfortunately, I'll have to remember to check this out when I get home or something similar.

Some notes in the code, others below.

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

DROP TABLE #mytable

CREATE TABLE #MyTable(

[ComputerName] [nvarchar](255) NULL,

[ApplicationName] [nvarchar](255) NULL

)

INSERT INTO #MyTable

(ComputerName, ApplicationName)

SELECT 'DCZC445645S','1E NomadBranch 3' UNION ALL

SELECT 'DCZC445645S','1E WakeUp Agent...

I take it back. Because of the length and datatype of your application information, there's a completely different approach I'd personally take here. Don't worry about the extra...

gary.harrington (9/27/2012)

---

My apologies - my original post was using over simplified data. My real data has a list of computer names in column A and names of installed applications...

Ron,

My only concern here with altering to a cascading deletion is that unless it cascades to duplicates as well you end up with a righteous mess. The OP will...