If you insert all your sample data into #temp, then run my query, how does it not do what you are asking?

create table #temp

(

ID INT,

[Description] VARCHAR(100)

)

...

select Id,

substring((SELECT ( ', ' + Description )

...

Thank you, Peso.

I did not ignore your suggestion as you can see.

The server switch did it.

This guy has 3 instances of SQL Server 2k5 on him.

Elliott W (7/10/2009)

---

3 Stupid questions.. Sorry I have to ask (bad experiences when I didn't)..

1. Is the sproc actually owned by dbo, did you specify that when compiled..

2. Is...

bcp "exec db1.dbo.[usp_testproc] 'test'" queryout "Y:\files\test.csv" -c -t, -T

all on 1 line...

Yep, that's what we got, along with a bunch of big 'ol wide flat file tables.

Its a mess, trying to make it do what it can until we can...

The function is of the form:

create FUNCTION [dbo].[fn_GetDescription]

(

@pID INT

)

RETURNS nVarchar(100)

AS

BEGIN

-- Declare the return variable here

DECLARE @Descrip nVarchar(1000)

-- Add the T-SQL statements to compute the return value here

SELECT @Descrip = ...

I should have mentioned that all 70 of these columns look up a value from the *same table*.

I tried replacing the inline calls with self-joins (yep for all 70 of...

How feasible is it to use BIDS 2005 in VS 2008?

If i understand your problem, the solution is pretty simple.

Use a select with a range:

SELECT F1,F2,F3,F4,F5,F6,F7,F8,F9

,f10,f11,f12,f13,f14,f15,f16,f17

,f18,f19,f20,f21,f22,F23,F24,f25

FROM

[Sheet1$A7:Y9000]

Set the range to the first valid row through the max of whatever possible...

Maxerrcount is set to 5! Me thinks that may be the problem....

bang.prashant (8/20/2008)

---

I m using

http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html

to move and rename a file.

help me for below expression and add date & time in below expression as it gives file name as abc-82008...

Hello,

Wanted to let everyone know that we found the root of our GNE. After calling Microsoft, we nailed it down to many TCP/IP ports being left in a time_wait...

Ironic, I had to do this yesterday. Not because of a crash, but because the client did not send a restorable backup, just a zipped up .mdf file.

I did...