davidn

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 similar to the social security number of the US.

*edit* I misunderstood your post, sorry.

You probably could run an update after each delete that would look something like: [code=SQL] UPDATE number1 SET number = number-1 where number > *deleted name id num* [/code] and just set the *deleted name id num* to the id of the one you just deleted.

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 select your mdf file and it should work. If you don't have that tool, it can …

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: [code=SQL] select max(totalnames) as highest_total from ( select state, count(names) as totalnames from t3 group by state) as temptable; [/code]

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

Hi, You can do something similar to what I did below. [code=SQL]update products set p_price = p_price * 1.10 WHERE p_code LIKE 'ffc%' or p_code LIKE 'dcc%';[/code]

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 one. Removing the -p will get rid of the prompt.

[QUOTE=Venom Rush;898798]Hmmm, I've tried joining the two tables with a normal join, left join and a right join but they all come back with the error of "Column 'code' in field list is ambiguous" I think this may be because the code column in Table Cart has multiple entries of …

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