Link to home
Create AccountLog in
Avatar of ExpertKapur
ExpertKapur

asked on

How to search the greatest count among four temporary table.

I have four temporary tables, they are billingaddress, postaladdress, shippingaddress, officeaddress now there are different number of rows in each table. I want to find out which of them has highest number of rows and assign the variable @x that value. how to get the highest count(*) among 4 #temporary tables?
ASKER CERTIFIED SOLUTION
Avatar of rushShah
rushShah
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account