roger.plowman (11/10/2010)

---

GSquared (11/9/2010)

---

I know what deterministic means.

So what you're saying is that you're an industry insider who knows that there's a huge security flaw in the product your company sells,...

The only thing I see on that one is a suggestion that you make sure the replication agent is running under an account that has the needed rights on the...

Microsoft has some good examples if you look up XQuery on MSDN.

Try this:

select cast(AvgMins/60 as varchar(10)) + ':' + right('00' + cast(AvgMins%60 as varchar(10)), 2)

from

(Select sum(fix_time/60)/COUNT (*) as AvgMins

from DB

where suppgroup = 'XXX') as Sub1;

The percent symbol gets the modulo (remainder)...

Yes, you're making sense. And the issue makes sense too. It's going to be some issue with stats vs execution plans vs query complexity vs etc vs etc....

I agree with a previous post that it doesn't have to be perfect, it just has to be better than the current system, which is more lethal than any war...

kl4576 (11/9/2010)

---

I actually expect to have NULL columns dropped, and not appear in the resulting XML.

The problem is that the whole variable @XML is set to NULL when [msdb] is...

Can you simplify the outer query by getting rid of the view and including only those tables and columns that the outer query really needs, instead of the whole complex...

Mike Caldwell (11/9/2010)

---

It's a time clock. People...

Mike Caldwell (11/9/2010)

---

I know what deterministic means.

So what you're saying is that you're an industry insider who knows that there's a huge security flaw in the product your company sells,...

Mike Caldwell (11/9/2010)

---

Actually, fingerprints are done as vector graphics, essentially. They work on points on curves, which are mathematically described, not on bitmapping (like a JPG). At least,...

For XML in T-SQL drops null columns by default. You have to use the XSINIL option to get them. That's probably the problem.

You're welcome.

It's because the whole view is built around that column. It's got Not Null checks, joins, et al, in there, and it's indexed (looks like it's the PK and...

It basically says, "I don't care if the data is being used somewhere else, and might be updated or deleted, give it to me anyway".

The use is when speed matters...