you can use SELECT ERROR_LINE() to get the line the error occurred on.

ha, thats what i came up with 😀

the only way i can think of is to have the 'commonly viewed parameters' as a seperate 'one-tick' option.

perhaps like this?

select case when @type1 = 'RFS' THEN

case when @type2 = 'RFS' THEN

case when @type3 = 'RFS' THEN

case when @type4 = 'RFS' THEN 'ALL' ELSE @type4 END ELSE @type3...

i do: select FLOOR(2.86)

I actually think celko has a point with his comment here. I certainly think its something that should have been brought up

It's not as bad as sOme of his other...

there's an answer at the bottom of this page

http://msdn.microsoft.com/en-us/library/ms174979(v=sql.105).aspx

it states:

Allowing an extra comma after the last column definition makes the code easier to generate and maintain because all lines can...

Genius, Mark! thanks 🙂

as you can see, i had a play around with the 'sql:variable' syntax, trying to get that to work for me, but your advice works like a...

EDIT.

i say 'there are 400 code'. what i mean, is that there could be upto 400 'code'.

in practice, 0,1 or more of the 'code' could be filled in.

i got this question wrong initially. now its changed my answer and says i've got it right:w00t:

based on the code above:

DECLARE @VALUE INT

SET @VALUE = 101

SELECT

*

from

Apprentices

WHERE

1 = case

when @VALUE = 103

then 1

when @VALUE = 101 and id in ('TX','CA','NM','AZ')

then 1

when @VALUE = 102 and...

SGT_squeequal (7/10/2012)

---

there is a report that you can run that till tell you who last changed the stored procedure and when. from ssms navigate to your database, right mouse click...

aah well, never mind. thanks anyway 🙂

I shall have a look at Source Control products out there and what they do.

cheers

declare @table table(id varchar(50))

insert into @table

select 'PSSA Math'

union all

select 'PSSA Science'

union all

select 'PSSA Reading'

union all

select 'PSSA Writing'

union all

select 'PSSA-M Math'

union all

select 'PSSA-M Science'

union all

select 'PSSA-M Reading'

union all

select 'PSSA-M Writing'

select

SUBSTRING(id,...

i've only just learnt about the OUTPUT clause but it is extremely useful.