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...

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 our rapidly changing...

Magy (12/16/2009)

---

Using an order by clause on the newly populated table will not work because there is nothing unique about the data. That's why I was hoping the...

The error message pretty much tells you what is wrong. The password for the account attempting to login to the server has expired. You need to change the...