Depending on the data type & how you write the query, the MAX should work too. I've just found that the TOP... ORDER BY works better especially with a clustered...

I think that your SQL Server instance is running under the local service account and does not have access to the network. You either have to expose the network to...

Below my post is a button that reads "Add Topic"

Click that, fill in the blanks and more people will see the question.

I take it my answer wasn't helpful.

I don't know if I'd place a hard value on it like 1mb, but I suspect he meant that since table variables have no statistics, they're quick to build &...

Yeah, that list seems a bit light. I'd ball park it. If you're close, go for it. Unless it specifically states something like "Extensive expertise with MDX" or some other...

sg2000 (1/10/2008)

---

I have a View defined as:

SELECT dbo.TabA.Col1, dbo.TabB.Col2

FROM dbo.TabA LEFT OUTER JOIN

dbo.TabB ON dbo.TabB.ForgnKey = dbo.TabA.PrimKey

In this case, I got all of TabB col2 on the View...

You must have a trigger in place. Simply running that query as written should do what you want. Why you need to keep two copies of the same data I...

Oh, and if you want more responses, post your question as a new topic. You'll get a lot more people reading it that way and you'll probably get better responses.

If I understand the question, it sure sounds like a similar issue. If your SQL Server is running under the local System account, it might not have access to the...

Echoing Gail, I'd like to get my 2008 skills to an adequate level. Also, I intend to try to present at PASS this year. Other than that, learn, improve, grow...

We ran into a problem recenlty where an app was leaving open connections and open transactions that were filling tempdb. You might look for old open connections, especially since it's...

Don't try to compare what you know to Itzik. I've taken his advanced tsql class twice, read tons of his articles and his books and gone to his lectures at...

Hey Sandy,

We are actually, for the moment, not looking, but only because we took on a consultant after spending a year trying to find a senior level dba. It's...

Reading this made me think of my red-neck, hillbilly inbred cousin who said, and I quote, "If they don't have it at Wal Mart, we just don't buy it."

So, assuming...

EXEC @ReturnValue = procname @param='value'

We use this in a pretty common fashion with the added code:

IF @ReturnValue <> 0

BEGIN

--handle the error

It works under the assumption that the procedure is going...