Yes here it is...

USE [AA_Helper]

GO

/****** Object: UserDefinedFunction [dbo].[fnSplit] Script Date: 7/2/2014 12:53:58 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[fnSplit]

(

@RepParam NVARCHAR(4000)

, @Delim CHAR(1)= ','

)

RETURNS @Values...

Could you provide any sort of example of what you mean, like I said I'm new to SQL development. I have always had a competent DBA that had things setup...

yes..The only thing I am converting is the date, it is of course a string in the text file and when I substring the text file I nvarchar it and...

Here are the indexes on these tables, so how do I eliminate CONFLICT_EXPLICIT?

I guess I should have asked differently, what are some good resources for reading to do this?

So let me ask what is the best approach for setting up a Data mart as it looks like I am going to be the one to do this, and...

I am not seeing where it is saying conversion problem, I do see the remote query problems, which I told my lead that this was going to be a HUGE...

Nope that is the way they have things setup, these are all linked servers..

I have attached my execution plan, I ran it last night and it was taki9ng approx. 15-20 minutes to run, today it is running for 30 minutes and still not...

http://stackoverflow.com/questions/30222/sql-server-get-data-for-only-the-past-year

We've showed them that they are losing 10's of thousands of dollars yearly because of this bad data, they are giving free service to customers because they can't track all...

It is even messier than that, I created a ETL package that cleaned it up even more, but after importing all of the files I am processing, found there was...

I fixed the issue, they had changed permission to the directory I was copying the files to, so I just granted permissions to that folder again.

Worked means successfully completed the operation of reading the data within the flat files, inserting it into a table as One column, then copy the file to a different directory,...

I used the code you supplied and it works correctly, but the contact information is from a different table(alcont) this table is from a completely different system, I AM INCLUDING...