Few points

😎

polkadot (5/2/2015)

---

The...

Here is a partial solution, it matches the city/state but does not remove them from the address.

😎

Sample data

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_ADDRESS_WORKTABLE') IS NOT NULL DROP TABLE dbo.TBL_ADDRESS_WORKTABLE;

CREATE TABLE dbo.TBL_ADDRESS_WORKTABLE

(

...

Talib123 (5/2/2015)

---

All

How long should the latest TLOG backups be kept on tape before the media is recycled. Some suggest 2 weeks. This seems very short to me.

Corruption issues could be...

Quick question, are you using Full Text Search?

😎

Jeff Moden (5/2/2015)

---

My problem with Try/Catch in such situations is that such situations should not occur at all. Either the data is bad or the query is bad. ...

Such reliance on defaults never ceases to amaze me. First thought is ignorance and competence, finding databases on the OS drive when the server has 15K spinners for the data...

Quick suggestion, use cross tab aggregation, here is an example

😎

-- if temp table exists...drop it

if object_id('TempDB..#exams','U') is not null

drop table #exams

-- create...

jerald.wilks (5/1/2015)

---

Hi,

I am using SSIS 2008 to attempt to send data to a web service. The web service contains complex types which are not supported within Web Service Tasks. I...

Jeff Moden (5/2/2015)

---

Heh... it wouldn't be "quick" though because it wouldn't be SARGable if the same formula the OP used were...

KGJ-Dev (5/1/2015)

---

Hey Guys,

thanks for your reply.

I Eirik,

before i though of posting on this forum, i thought about using Jeff's delimit function what you have suggested. But i am sorry that...

polkadot (5/1/2015)

---

Does anyone know the fix?

Have read this article and tried suggestions: http://stackoverflow.com/questions/10888616/why-is-ssis-complaining-that-there-is-a-partial-row-at-the-end-of-the-file

have read this KB article stating it is a known bug with a SP fix for 2005...

Quick example

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

/* SMALLINT MAX = 65535 */

DECLARE @SAMPLE_SIZE INT = 65535;

;WITH T(N) AS (SELECT N FROM (VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL)) AS X(N))

, NUMS(N)...

Train

Quick suggestion, generate the sequential bits separately and use the stuff function to merge it into the guid.

😎

Quick thought, schema qualify the table name by adding the schema name + dot prefix.

😎