If the milliseconds are being dropped the data is being stored as smalldatetime or prior to the insert it is smalldatetime. To get equality you need to convert the...

Are you using an Identity Column as your primary key in each database?

If you are you can use Set Identity_Insert [table_name] On and keep the same key values. Then...

That's what drop database does. If you use SSMS to do it, you are given the option of deleting backup files as well.

The format should not affect the determination of equality as SQL Server stores datatime as a numeric behind the scenes. As far as forcing the data to look the...

First if you are working with a sub eport your main report needs only 1 dataset for the voucher data and your subreport will have the dataset for the funding...

GSquared (5/1/2008)

---

My favorite way to do this on tables where you query this kind of thing regularly, is to use indexed, computed columns.

Alter table dbo.MyTable

add DateYear as datepart(year, MyDateColumn),

DateMonth as...

One suggestion I would have would be to possibly create a computed column on the table that does not have the time, well, has the time set to 00:00:00. ...

Drop Database [db_name].

I'm not sure what you mean by everything associated with it. As dropping the database drops everything in the database.

What is the exact error message you are getting?

Is this query being run on SQL Server or ORACLE?

I ran a similar query in the AdventureWorks database...

Sorry I used cross apply which will not work in SQL 7, 2000, I did not check the forum we were in. The numbers table solution can still work...

It took me awhile to find it, but I knew I had read a solution to this problem using a Numbers table. Check out this article: http://www.sqlservercentral.com/articles/Advanced+Querying/2547/ and the...

I knew my query would return more results than yours, but it should have returned some data. The all 0's result means that there are records meeting the criteria...

I think salaries are more static than moving either direction, and have been in places I have lived for 2-3 years. I think it all depends on where you...

I believe the command is SETUSER. Look SETUSER up in SQL 200 BOL. I don't have a copy here.

Are there any indexes on the created table? Select Into will not create indexes.

Is the behavior the same if you do a subset of rows?