If I understand you correctly - you're looking to create an xml fragment using for XML Explicit, and then insert it into an XML column?

If so - you need to...

With the right covering index(es) - you'd have to have an awfully large DB before pre-generating would be worth it (IMO)...

Glad that was helpful.

Other notes:

- Unit test coverage (and better yet Test driven development) of the data provider is CRITICAL. This is hard when you introduce a state machine like a database -...

Greg Snidow (2/15/2008)

---

Well, I do not want to...

If we're talking about classic ASP - there's a serious "man in the middle" problem with SQL code being executed like that (on top of the "ASP is not encrypted,...

well - depends on what you mean. you can add parameters to a report, and since you can use a stored procedure as the basis of your report, I...

I know of two basic strategies. The difference between the two is whether you apply a specific payment to a specific bill, or if it just gets applied to...

Try this on:

with FinWeekCTE as

(select *, datediff(day,dateadd(year,datediff(year,0,dateval),0),dateval) / 7 %13 as weeknum

from dates)

select *, case when weeknum=12 then 5 else weeknum%4+1 end as finweek

from finWeekCTE

I know...It's just that this...

Jeff Moden (2/15/2008)

---

All the code does is multiply the DECIMAL and FLOAT versions of the number .3333 times an INTEGER. Notice in column 3 how early (3rd row)...

Well - you only have two options: either make the field it's going into bigger (right way), or make what is to go into to it smaller (not the right...

Just for giggles - have you considered using LDAP queries instead?

LDAP actually has an OLE DB -type provider, so you can actually set your Active Directory as some...

What do you need further suggestions on? It sounds like you have a pretty good handle on things...

The one suggestion I can make (which was made by one of...

Jeff Moden (2/14/2008)

---

for the 4 person example using 99.99, you're gonna need a lot more scale than just "2" decimal places whether it's with float or decimal. Or, let...

Or - you could run reporting services and just send them a link to the report (which wouldn't need to change)...