I have a lot of references to it as a linked server in different stored procedures. I guess the migration/moving might be the way to go,

thanks,

Petr

Ooops, sorry, I did not scroll all the way down. Once I created the function, everything works awesome.

thanks,

Petr

OK, this looks great. I see the logic. What is the code behind dbo.DelimitedSplit8k?

thanks,

Petr

OK< I guess I can answer my own questions here :). I have to separate the declare and set into two statements.

Petr

How would I adjust the code so it works with SQL 2005 database?

thanks for all you help,

Petr

the database is 2005 version that is why I was getting that error,

PEtr

I know, I am definitely taking everything that is in the box. I even attempted to replace the ' marks.

not sure what is going on here,

Petr

When I execute the code, I get the following set of errors:

Msg 139, Level 15, State 1, Line 0

Cannot assign a default value to a local variable.

Msg 139, Level 15,...

This will be just a one time import from excel. I am not even going to set up a custom SSIS job. I will just use the regular SSMS feature...

Got it and I am sorry. I did not realize that.

The data comes over from a flat file import so I can convert the nvarchar to datetime. That does not...

here is the test data for projections:

USE [International_Forecast]

GO

INSERT INTO [dbo].[Projections]

([Brand]

...

Hi there,

appreciate the input so far. The reason why that particular column can be null is because the date might not be available at the time. The open date is...

DDL for forecast date (sales data)

USE [International_Forecast]

GO

/****** Object: Table [dbo].[forecast_data] Script Date: 7/16/2014 11:12:36 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[forecast_data](

[recID] [bigint] IDENTITY(1,1) NOT NULL,

[FileID]...

Yes sir, thanks again,

Petr

You sir! are a a lifesaver. I see how this is a much better way of doing this,

thanks for pointing me in right direction,

Petr