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 '12 at 05:51 AM
Aug 01 '12 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 '12 at 05:51 AM
Seen: 491 times
Last Updated: Aug 01 '12 at 11:58 AM
count several thing
Counts across different tables producing strange results
count based on two @table variables
Combine two queries
need to SUM from various dynamic tables
How do I count 0 records?
Count as a computed column
Count for Attendance of employees
count distinct number from only one source
how to count count child rows