Try this:

WHERE date >= convert(datetime, '2009-12-16 00:00:00.000, 121', 121) and date < convert(datetime, '2009-12-17 00:00:00.000', 121)

Actually that isn't what Jack asked for. If you read the article he suggested (also happens to be the same article I reference first in my signature block as...

Glad I could help.

Probably could if you provided table definitions, sample data, and expected results based on the sample data. Not being a Foxpro programmer, I have no idea what it is...

rpatil22 (12/16/2009)

---

1. Create table say table1 with column col1 as varchar(2)

and col2 as datetime and add default constraint to col2 as getdate()

2. Insert into table1 ( col1,col2) values('a') -...

Doing that, you are probably going to need to looking to mirroring your databases. As this would be for reporting, I'd look at asyncronous mirroring of the reporting database.

I...

I don't have that issue with my wife when it comes to sports. She isn't a real sports fan. She likes to root againt my team (football, Denver...

Let me guess, not her? 😛

Glad I could help. But, please, take the time to read those blog posts as well. 😉

Sounds like a classic case of parameter sniffing. It may benefit this stored proc to declare local variables and assign the values from the parameters to those local variables...

I just saw this, and I have to say that this solution is not ideal. You really need...

Not overally fond of baseball, but if I had root for a team, Colorado Rockies. Sorry, born and raised in Colorado.

GSquared (12/16/2009)

---

Lynn Pettis (12/16/2009)

---

Also regarding the company providing training; it's nice when they do, but in the end it is up to us to keep ourselves current and relavent in...

Creating the expected results is really a manual process. Look at your sample data you provided, what should the result set returned look like, what is the correct answer?...

ray 78019 (12/16/2009)

---

I inherited an existing Access application with a SQL Server backend. The previous programmer did not use any IDENTITY fields in his table. So all primary keys are...