SQl Server

[kujawski]

Is there a limit to the number of rows that the count statement can reach , as i have an sql query joining many tables that should return a row count of around 200,000,000,000 rows but falls over with the message 'Arithmetic overflow error converting expression to data type int.' , if i put in some criteria that filters out a lot then a count is returned, im counting on an ID field.

[fever28]

look at the size of the email is it large enough to have a pic?

could be just a html page with a link to a pic thats hosted else where either out of date or your own software is protecting you form connecting to a web site to get pics

[fever28]

sorry wrong window

I have DB's at work with 30 million plus rows so doubtful there are other limits though like how mouch is in each cell, table