According to the example, not only does the object names differ, but also column names - which leaves the equality test to just be about columnorder and datatype match..?

If so,...

If nothing else, maintenance and debugging also becomes much easier when things are written explicitly.

/Kenneth

Also be aware that the information_schema.* views only return results within the context of the executing user.

ie - if you're logged on as (any) user, and there is a table...

That is as simple as it gets

If you think about it (try to do the math yourself) - if you were to sum...

Can you expand on what is not working?

Errormessages? Nothing seems to happen? Something happens but not what you expect?

Further, after the function call (ie you have a string to be...

I believe the quickest / easiest way would be to load the file into a table, then read the number from there.

You can use isql/osql/bcp/dts etc in order to get...

Can you post an example of the query you have?

/Kenneth

Unfortunately, the resolved errormessage isn't trappable from within Transact SQL.

A method to avoid this problem could perhaps be to avoid inserting duplicates into a unique constraint? It's not that...

Have look in BOL at the chapter called "Creating and Managing Traces and Templates". It's a good place to start.

/Kenneth

What you're asking for is how to tokenize the input variable. Not easily done in Transact SQL, and tend to get pretty ugly when attempted. It's not optimal and don't...

Easily? Without any distinguishing charachteristics? Can't be done "easily".

Anyway, you'll have to loop through the entire string until you find the ip (or...

Well, good luck

This seems to be a security context issue and/or firewall blocking.. Make sure you keep track on each step and what...

Either loop through all 8 tables, as you suggest, or do a:

select  min(x.total)

from

     (

       select total from table1 where...

       union

       select total from table2 where...

       union

       select total from...

Here's one way to do it. Adjust datefirst and/or the offset in dateadd() functions accordingly for what start-end days you want.

-- The example shows how to find out...

Try talking to the security/firewall guys..?

/Kenneth