Most of the study sites center around dumps of the questions and really this is not teaching you anything other than what the test has on it. The problem with...

I have run DTS packages simultaneous before and have seeen no issues, however the datasource was not changed so I cannot be sure what the side effect is, I believe...

Ok found this out, for some providers you have to have Distributed Transaction Coordinator running. When I turned it on I got the error for an Access database that Jet...

Tested and I always get an ODBC error, may just not be allowed under those circumstances, I will look for details and post if I find.

"Don't roll your eyes at...

Or try this, already put in stored procedure format:

CREATE PROCEDURE ip_GetMenuHier

@t_Menu_pk int --The bottom of the hierarchy.

AS

/* Create a local temp table to store our output until ready. */

CREATE...

Try this, this joing the two together to perform one select, barring any misunderstandings I have about your data this should work or at least give you some idea how...

Hey Andy, I would appreciate that code too if you'll write it.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

I saw the movie, isn't the line

Loke, I am your..........MOTHER. (Thumbs Wars, much better than the original)

"Don't roll your eyes at me. I will tape them in place." (Teacher...

Actually I would go this route with SQL

WHERE CONVERT(VARCHAR,mydate,101) = CONVERT(VARCHAR,GETDATE(),101)

This has IMHO less overhead on the CPU in comparing since both sides are converted and compared in the following...

You know I always thought that as well, but if you look at a composite index under Show Execution Plan when quering for say State even if it is column...

quote:

---

so if more quiries use City then City, State or if more use State then State,City

---