Instead of SELECT @RetVal in my above example,

select left(@RetVal,len(@Retval)-1)

Returns everything apart from the rightmost character. This may be what you need ...

--Edit: fixed inconsistent formatting

Comment deleted. I answered the wrong question! +1 to Alvin's answer.

There's a post which may help you here.

Here is a solution which relies on Jeff Moden's infamous '8k Splitter'[/url].

It assumes that the DelimitedSplit8K function has been created in the database you are going to call it from.

if...

When you call this function, will you always pass exactly 2 arguments (eg 1 2), or do you want to pass a parameter list with a variable list of params?

Have you recently renamed your SQL Server instance?

cbrammer1219 (10/10/2014)

---

Ok...This may be a strange question< but after the first initial load would I need to changed this SSIS package so it wouldn't reload all of these tables again....

In...

Deleted comment

With the numbers' you're talking about - you're going to have to address a way to compare like attribute to like attribute. Since you said that the attribue ID's might...

I am wondering whether it would be worth producing properly normalised tables in each of the databases. I'm thinking along the lines of

(CustId, AttId, AttValue)

These three values could form...

Paul Stasny (10/9/2014)

---

Phil,

Thanks for your reply. I'm not clear on what you are suggesting. The only thing that links the two databases is the custid and custcode values. Based on...

Perhaps you can change your approach slightly – how about modifying your queries to run independently and produce lists of row counts, sums, checksums, whatever and then comparing those results?

Never mind your old friend. Your...

Try running this and the answer will become clear:

DECLARE @strdate varchar

SET @strdate = '2004-01-01'

select @strdate

By declaring your variable as Varchar but without a length, SQL Server assumes a length of...