Does your function have to split a string declared as nvarchar(max)?

SCH70 (3/27/2013)

---

This is the closest thing I have found over the past few years. MS has shied away from promoting the true system tables so people don't code against...

No gals on this thread, yet.

churlbut (3/27/2013)

---

Seems like this article is like old news, not only do I see this mentioned quite often in forums when I have time to check questions, but now its...

Check out the resources with this article: http://www.sqlservercentral.com/articles/Tally+Table/72993/. You should find a CLR splitter that will meet your needs.

Be sure to read the article and the discussion with it.

A rough guess based off a very flimsy description of what you are trying to accomplish.

declare @SQLCmd nvarchar(max);

select

@SQLCmd = stuff((select N'union select MFG from ' +...

jbalbo (3/27/2013)

---

I get Incorrect syntax near ')'.

But can't find it?

here is everything

O

/****** Object: StoredProcedure [dbo].[jb_test_deleteme_sp] Script Date: 03/27/2013 14:18:42 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[jb_test_deleteme_sp]

(

@StartDate...

Have you tried? If so, did you get an error?

Also, you really can't compare the pricing of SQL Server to that of Oracle without adding all the features you get in SQL Server at no additional cost to the...

It is a part of BIDS. I haven't worked with SSIS for a while so you should do some research in BOL (Books Online).

Have you tried deploying the package from BIDS using the deployment tool?

Not quite:

select count(distinct source.col1), DATEPART(month,datecol)

from

(

select 'name1' col1, '1/1/12' dateCol

union

select 'name1' col1, '1/2/12' dateCol

union

select 'name3'...

You have fallen into a common trap. Just because ISNUMERIC(adc.value) = 1 is true does not mean that convert(decimal(11,2), adc.value) will work.

Please read the following article: http://www.sqlservercentral.com/articles/IsNumeric/71512/.

How are you deploying the package?

Or, another option using smoke and mirrors inside the WHILE LOOP:

set @sql = 'create synonym MyTarget for ' + @C1_NAME + '.dbo.MyTable';

exec (@SQL);

select * from MyTarget

drop synonym MyTarget;