i would try putting the whole code, including the code between the 'fetch new from' lines and the variables your declaring, within the @query and execute it as one.

declare @table table(name varchar(10))

insert into @table

select 'CAPS'

select * from @table

update @table

set name = upper(SUBSTRING(name,1, 1)) + lower(SUBSTRING(name,2,len(name)))

select * from @table

something like this? or have i over complicated things?

doesnt the first line satisfy all potential outcomes?

if 'property' = 'prop2' then it will be 'IN ('prop1','prop2','prop3')'

or have a misread?

Paul_Harvey (2/5/2010)

---

Not at all. The issue I had was that it was allowing addresses though WITHOUT the .com on the end. ie text.text@gmail

Phils amendment to my expression now means...

sorry, are you saying that you dont want to let email addresses through that follow the format 'text.text@gmail.com' ?

because thats the format of my address

Chris Morris-439714 (12/8/2009)

---

davidandrews13 (12/8/2009)

---

Chris Morris-439714 (12/8/2009)

---

Hi David

This implies that you can only update one column, of one row, per statement - is this correct or am I missing the point...

broadly speaking,...

sorry, i'm still getting used to what info is required, while at the same time not giving too much of our database structure away.

hopefully this is enough information to make...

OK. here's a slightly updated version. as you can see from the stored procedures that do the update, all but one parameter is hardcoded.

the parameter that isn't hardcoded is...

excellent! using Madhivanan's link i've now got rid of my cursor 🙂

i dont think it makes to much difference in this situation because its currently only bringing back 7 rows...

this did confuse me when i first started getting different results in a left join

Lynn Pettis (12/4/2009)

---

Please, when you get a chance, go back and eliminate the cursor. Since there is a set-based solution, you really should use that as it should scale...

1234567teamNo

NULL114310NULL6NULLNULL6

startdate enddate teamName

03 Dec 200203 Dec 2009Wales

the current data will show it as this. it should all be on...

OK. its a bit difficult for me to give some test data for this because the declaring of the temp tables and filling them would have to go into the...

thanks everyone. got it to work. 😎