of course you may be able to get away with this depending on your tables

UPDATE fl SET radicaltipoemp = 1 where radicaltipoemp = 0

does ALMOST the same thing but if...

luissantos (4/2/2012)

---

Hello Lynn

i don´t understand your comment:

"you have to copy them to another query window and run them."

Do you refer to copy all the result into another TSQL windows...

depends on what you are trying to accomplish. if you need...

can you post the DDL scripts to create your tables and some sample data? if you are unsure how to do this please check the article that is linked...

aaron.reese (4/2/2012)

---

My preference for this would be the use of CTEs (Common Table Expressions); I find this the easiest way to visualise a problem because you can break it into...

glad to hear you got it solved and i put you on the right track.

finally we can get back to the OP's question if you have not scared them off.

on a side note: there is a table in our database approaching 900...

this kinda sounds like homework. since you want all rows where its all null you have to use the queries you provided.

now lets move to the total idiocy of...

192.168 is a class c private network (your internal network) while 204.224 was your external facing ip. from the error looks like you need...

i started reading that and then...

ive been wondering how your doing over there. i stopped reading just so i would not make comments that would come across as rude. are you to...

what did you do to make him leave??

im on most weekdays.

not just jeff. every? poster has said he needs to some way add identity to...

Z1024 (3/30/2012)

---

opc.three (3/30/2012)

---

Z1024 (3/29/2012)

---

For tables with millions of rows you should really be careful with indexes, It can take literally hours (on commodity hardware) to delete say 10k rows from...