was going to edit my post on that one but just got lazy...

"all" as in "all also"...it is forgivable if made by an American...

...

CREATE PROCEDURE dbo.A

  (
   @PersonnelNumber As Integer
 

as
Declare @DisciplineID Int
 SELECT   @DisciplineID =  e.DisciplineID
 
 FROM    Employees e
  
...

3 minutes late....and another perspective ???

create procedure sp1
@parm1 Int,
@parm2 VarChar(25),
....
as

select @parm1 = col1, @parm2 = col2 from myTable where....

if @@rowcount > 0
   begin
      exec sp2 @parm1, @parm2......

since we were talking about perspectives a few minutes ago...how about if you just check to see if a match exists...

if exists(select * from dbo.Transactions where UserID= @ClientID)
 ...

Yes, of course...didn't even think that may have been the intention...just goes to show that the more "eyes" that look at something the more perspectives there are...

The way I do it is by using the old table script...changing all the names (table, contraints, keys etc..) to the new ones and then running it in QA...

Unlike you sswords - I continue complaining (must be either my nature or the fact that I'm female ..)

As for "chinese whispers" we...

"Always comes good at the end"...is that the voice of a sore loser ?!?! If you've noticed - Remi stepped in with a very weary tread - none of the...

ha David - another one for remi! Not that anyone's keeping tabs!!!

btw:which of the 2 avatars you've posted so far is "more you" ?!?!...

Jumping in here...

Well - I' m from neither here nor there but have long ceased to lament the misuse/abuse/demise of the English language - sadly enough qed3 - it was...

using rsharma's solution...here's how you would use the substring...

declare @string varchar(100)
set @string = 'F49-000 BAL:4743 64 FINISH_STD:ES'
select charindex ('bal', @string)

select substring(@string, charindex('bal', @string), 11)

Manish - if you search this site you should find several posts with similar issues - here're a few that you could look at..

8k or bust

8k characters

exceeds...

are these "people" the same person - meaning is it husband & wife; people sharing an apmt - or just the same person with more than one job ?!

Is there...