I agree with mkeast. Stick to yyyy first specially when your start to hit client non english but server english, etc.

A few echos may get in the way of "From an employer's perspective, if they want to attract and retain more females in IT, they should make the work environment more...

Think Robert Davis  second one is better.

Stay away from OR's if possible.

Select ColLIst FROM dbo.TableName

Where

(Case When @Par1 Is Null then 1 When @Par1=SomeCol1 then 1 Else 0 End)=1

And

(Case When @Par2 Is Null then 1 When @Par2=SomeCol2 then 1...

Have a look at http://www.windowsitpro.com/sqlserver/forums/messageview.cfm?catid=1666&threadid=131185

I'll go for a function which returns a table and pass in which product(s) your are interested in.

Nice example, I have been indoctrinated not to use GOTO's at all but rules a made to be broken.

Create Procedure TestB (@Parameter1 Varchar(10),@Parameter2 Varchar(10) Output) as

 Select 'Inside TestB @Parameter1 : ',@Parameter1,'@Parameter2 : ',@Parameter2

 Select @Parameter2='1'

Return

go

Create Procedure TestA (@Parameter1 Varchar(10)) as

 Declare @Parameter2 Varchar(10)

 Select @Parameter2='1',@Parameter1='0'

 Select 'TestA Before @Parameter2 :...

Can you try alzdba  example.

Add "if (Select count(*) from inserted)>0" as Alan Palmer  suggested.

Please...

Sorry should have typed :

                                Personally I not do like the "IN" clause will try and remove that aswell.

Will have a go at it tonight but for starters I'll limit the "group by" statement to the inserted table data only.

Other words "group by" only on the data you need,...

How many records in tblPremPolicyPremium?

Which version of SQL?

Do you have recursive triggers switched on?

Do you run Active Directory in your environment or can try logon scripting or manually visit each workstation or email each user a .reg file to double click.

Can you supply a bit more detail?

Not much help but read through article at http://support.microsoft.com/default.aspx?scid=kb;en-us;q306518 

Try an connect from web server with a tools which give more information on the...