kevriley (5/14/2008)

---

Hi all,

had a strange error yesterday with SSRS 2005.

When I attempted to open a report through the Report Manager (i.e. http://MYSERVER/reports) I got the following error

unable to...

Anirban Paul (5/11/2008)

---

Abosolutely. What I like most about the discussions is that you can't just write 'casual' writing. You have to be absolutely sure about the content before putting it....

Shamshad,

Unfortunately, your question and explanation are still too broad to provide code or examples.

You mentioned you're calling a C# (ver. 3.5) DLL??

If you've started down that path, you...

Hugo Kornelis (5/7/2008)

---

Shamshad Ali (5/7/2008)

---

Thank you all for your valuable replies. I would like to appreciate if some one make a scenario (simplest one mapped to my problem) and provide...

Hugo Kornelis (5/7/2008)

---

Shamshad Ali (5/7/2008)

---

Hello,

My quewtion is related to replacing loop, I am very interested on this. coz i really want to improve performance and I can't find a...

Another most excellent and fantastic article Jeff.

😎

EDIT:Sorry for continuing on Matt's off topic response...Last one I promise.

---------------------------------------------------------------------------

EH? Wait a minute...

Sorry for posting before thinking...sometimes my fingers are faster than my brain.

Maybe Matt is confused. 🙂

According...

Mike C (3/27/2008)

---

Matt Miller (3/27/2008)

---

Mike C (3/26/2008)

---

Yes, performance enhancements would be welcome, but OTOH I can just imagine the complexity involved in doing what CROSS APPLY does. Hopefully they'll begin...

The light finally went off...

for each "section" I need to cross apply it to do what I want.

Example below:

SELECT

x.value('UnparsedName[1]', 'VARCHAR(20)') as Name

,l.value('@BusinessType', 'varchar(20)') as BusinessType

,CAST(CONVERT(varchar(20),l.query('HighBalanceAmount/text()')) as money) as HighBalanceAmount

FROM...

cmille19 (3/26/2008)

---

Another way using xquery if you have multiple Name elements as noted in this blog entry

http://blogs.msdn.com/mrorke/archive/2005/07/21/441554.aspx

SELECT T.ref.value('.', 'varchar(256)') AS Employee

FROM

(

...

Sir Slicendice (2/19/2008)

---

The TVF would run faster and be far more portable than relying on pushing the button; the button could move or be removed at any point..... But...

1. Click Topic Options in the blue title bar above top most post on page.

2. Click Print Topic

3. Have...

TheSQLGuru (2/19/2008)

---

Hey, anyone know if there is a way to extract out all of the 200+ posts for this thread into a single document? I would very much like...

Sir Slicendice (2/19/2008)

---

Well, you sure can age these: all line items for the 10 accounts that have the longest period without a transaction and that have a positive current balance:

select...

Ah, which is how we got on this track of guaranteed, ordered, lightning speed updates with...