Yes I was thinking of that, performance wise it will be better 2 stored procs.

However, I am not envisaging that I will have lots of data, if i will do...

cool that worked

the trick is the LEFT OUTER JOIN eh?

Thanks Bruce

I applied the following and it worked

WHEREexPlayerSurname LIKE COALESCE(@SearchText, '') + '%'

Adi Cohn (11/28/2008)

---

You can...

Chris Morris (11/28/2008)

---

Thanks Johann - more than one row returned would have indicated a slightly different table-based solution. Anyway, reckon this should do the trick:

[font="Courier New"]SELECT @BuildID = BuildID

FROM...

Chris Morris (11/28/2008)

---

Hi Johann

Looking at this from a slightly different angle...which variables do you have populated before you run this bit of code (nicked from Gail's post, thanks Gail)...

SELECT @BuildID...

Hi All

this worked

SELECT @BuildID = BuildID

Adi can you tell me how I can do it with one delete and get a return value?

Thanks all!

the thing is that @BuildID is returning a value, since there is a row at the moment, for example 30023. However I am loosing that value then

Thanks for your replies guys

Yeah I should have added a WHERE clause.

I like Carpal's answer the most, since I have learned something new.

Thanks a lot guys!

Excellent

That worked perfectly.

Learned something new today 🙂

Thanks a lot Carpal!

yes I know

the problem is that all comparisons, wether ' ' were all returning 0

That was the problem

Thanks

SELECT @var = COUNT(*) worked!

Thanks for your help and time!

ah ok for next time then

Thanks for the help

yes excellent

Thanks a lot Chris!

ah ok

I get what you are doing.

You are filtering every step by the deleted, and then everything should be visible if the products.deleted is 0 obv

Excellent stuff

Thanks for your help...