Following on from Frank's post

select t1.c2, sum(t2.c2) as [RunningSum]

from #rt t1

inner join #rt t2

on t2.c1 <= t1.c1

group by t1.c1, t1.c2

order by t1.c1

Has the table...

CREATE PROCEDURE usp_copy_session

    @SessionID int,

    @UniqueID int

AS

INSERT INTO

(UniqueID, QuestionID, ColumnID, Answer)

SELECT @UniqueID, QuestionID, AnswerID, Answer

FROM

WHERE SessionID = @SessionID...

Probably too late but I posted this solution in another thread with the same question

order by cast(

(case when patindex('%[a-z]%',[col]) = 0

then [col]

else left([col],patindex('%[a-z]%',[col])-1)

end) as int),[col]

I picked the right answer which was recorded as wrong, now that the wrong answer has been changed to the right answer, I now have the correct answer and 1 point...

It has a .PNG (Portable Network Graphics) extension

Displays OK in IE 6

Is the file 'Fixed Field Length', that is each column is the same width which would describe your problem as the number of spaces would vary depending on how many...

What do you mean by 'empty' (null, zero?)

This will check for NULL

SELECT

 h.client,

 count(*)  as Count_Total_Slots,

 SUM(CASE WHEN h.Value IS NULL THEN 1 ELSE 0 END) as Count_Free_Slots

FROM database1.dbo.Hardware...

I agree Andy, I have seen some threads go 'cold' (I think this a minority though) which means you do not know if the solution(s) worked or not or whether the...

All output, errors as well are put in the output, whether redirected or if using the -o parameter.

Add

-m-1

to your osql parameters

Create your batch file like this

CALL batchfile.bat servername databasename scriptname1.sql

IF ERRORLEVEL 1 GOTO ER

CALL batchfile.bat servername databasename scriptname2.sql

IF ERRORLEVEL 1 GOTO ER

CALL...

I did see the solution in this Forum

If there is a solution then I'd be interested.