Any chance of some data Rod? if you follow this url: http://www.sqlservercentral.com/articles/Best+Practices/61537/ there are really clear instructions 🙂

Hi,

I've tried solving this with quirky update method, but having some difficulties!

Can't figure out how to add index to table variable? create index throws an error, declaring OrigID...

Hey Hunter, this site is fantastic, there are some real gems of articles (and folks) ...

Arrrgh! totally missed that, Flo, thanks for that.

Bugger, missed the empty case!

Here is Jeff's more elegant solution (full code found at http://www.sqlservercentral.com/articles/T-SQL/62867/

--=============================================================================

-- Setup

--=============================================================================

USE TempDB ...

Hey,

surely that is a charindex and substring question? Scratching my head trying to use one or the other...

DECLARE @String VARCHAR(64)

SELECT @String = 'Johnson Newyork'

select CHARINDEX(',', @String)

SELECT

...

You may be faced with no other option than to import the data into three tables in one dataflow, then perform you duplication-elimination in a second data flow.

That code is going to create a table called @account in your database! You’ll need to call a sql EXEC command. You’ll need to set

What type is the data column, perhaps it is a non-nullable type for the means by which you are getting data into database?

I understand the sensitivity issue, but without knowing anything about the source data structure I can’t really offer a lot of help. Perhaps you can describe a few lines?...

Hi,

What is the structure of the data? Can you post a sample?

I'm not clear why you need lookup tables, are you pulling some data item from one table to the...

Is the column into which you wish to insert a null value actually nullable?

What is the structure of the table? can you post the associated CREATE TABLE command?

Thanks Newbie 😉

All the best

Allister

D’oh! Brain based sql parsing isn’t up to scratch!

SELECT

ISNULL(T1.weekday, T5.weekday) AS Weekday,

ISNULL(T1.weektype, T5.weektype) AS Weektype,

COUNT(T1.orders) As 'OrderCount',

SUM(T1.CollectValue) as 'CollectValue',

T5.CancelCount,

T5.CancelValue

INTO #tempv

FROM #temp0 T1

FULL JOIN -- Changed...

You fix this with an isnull function (again, this isn’t tested, as I don’t have any test data):

SELECT

ISNULL(T1.weekday, T2.weekday) AS Weekday,

ISNULL(T1.weektype, T2.weektype) AS Weektype, count(T1.orders) As 'OrderCount',sum(T1.CollectValue) as...