I would like to count the number of balls given to the children and would like to link four different tables as mentioned below.
Tables are 1) Ball 2) lu_ball_disp 3) CN122_balls 4) Balldetail
Jul 26, 2012 at 05:51 AM
Aug 01, 2012 at 11:58 AM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Jul 26, 2012 at 05:51 AM
Seen: 608 times
Last Updated: Aug 01, 2012 at 11:58 AM
query for count
count users for past 7 days
Conversion failed when converting the varchar value '5.00' to data type int.
Summary of Transaction
Transpose 1 row
How to count based on multiple columns
Count text and numeric records
compare 2 table records
Multiple counts with multiple tables.