I'd imagine ithlep is talking about making a database that stores an ID for every citizen along with other personal information like their name, address, those sorts of things. Something possibly...

*edit* I misunderstood your post, sorry.

You probably could run an update after each delete that would look something like:

UPDATE number1 SET number = number-1 where number > *deleted name id num*

and just set the *deleted name id...

You should be able to do a group by on the state and then select the max of the counts of names.

It'd be something like:

select max(totalnames) as highest_total from ( select state,...

I would imagine storing it somewhere would be faster since it wouldn't require a whole scan/count.

You should be able to do the following in SQL Server Management Studio Express:
Right click on the databases folder in the object explorer and select "Attach" then "Add." From there you can just...

Hi,

You can do something similar to what I did below.

update products set p_price = p_price * 1.10 WHERE p_code LIKE 'ffc%' or p_code LIKE 'dcc%';

To clarify a little, you are getting a password prompt because you are specifying -p which is normally used as -p[password] but you are not supplying a password after the -p so it prompts you for...

Not to push the RDM product line too much but http://docs.raima.com/rdms/8_2/Content/UG/Chapter15.htm does provide an overview of replication and how it can be used.

If you want to do all the math through just SQL, you can do something similiar to the following:

SELECT session, SUM((markup/100.0* price + price)* amount * units) AS total FROM cart, fruit WHERE...