Try out this.

Select '2' 'orderfield', field1, Field2 from table1

union

Select '1' 'orderfield', field3, Field4 from table2

order by orderfield, <field> you want to order by

You could think of re-writing your query...

Could you explain the way (the logic)you are sending emails?

I am sure you would have taken care of this of changing the connection string so that it points to the production server.

Secondly is the Web Server and SQL...

This is DeMorgan's law....

Not(A or B) = Not(A) and Not(B)

Not(A and B) = Not(A) or Not(B)

Not(Not(A)) = A

Where A & B are Statements

Please refer the Collations, Overview section of BOL. It describes the Collation concept in detail. Check on the collation of ur 7.0 instance and 2000 instance.

How are you migrating the data to the new DB. DTS packages / DTS Export Option / Others?

This is something that I myself have been trying for quite some time. I don't think there is a way out. The "result set" defies the RDBMS concepts.

quote:

---

As long as none of the courses will ever extend more than 255 days, you could use SQL Server's built-in Numbers table:

SELECT...

The same query is answered in the TSQL section

do you have the bandwidth to use DTS packages? If yes you could create the sequence required before loading the data into the destination table.

Thanks

Lucas

First you need to create a table(could be a temp table - based on your requirement). This table(with atleast one field "dates") needs to contain all the dates for the...

Try this...

unceck the the "use fast load" check box in the transformation properties-->option tab.

This is an option that you could look at. Create the master table "Properties" with the comon attirbutes of all property types. Then create n number of specialized tables like...

Just to have a clear picture of your query. Do you want a transpose of your result set? Thatis converting your rows to columns and vice versa. In that case...

How do you represent th data in your database for events like "Management meeting every Monday"? Do you have a record for each occurrence or do you have a flag...