Currently: I drive 4 hrs (260 miles) twice a week (Sunday pm, Friday pm)

Last job: drove 1 hr each way (50 miles) once a week (WFH remainder of week)

Last job...

Steve Jones - Editor (7/8/2008)

---

Well I'm lucky. It's either 3 ft to grab the laptop off the dresser and RDP downstairs, walk 75 ft downstairs to the office, or another...

A view would be pre-compiled; therefore it could potentially be faster than a query which would need to be compiled. In practice, you may not be able to perceive a...

Good question!

But, even better, GREAT explanation of all of the answers. I wish that all of the QODs did the answers this way!

2 agents in one row is not normalized data. Split the agents out into a separate table, and you'll find that your...

Resolution:

when setting the parameter specifically to null, do it as:

Param[0] = new ReportParameter("Section", new string[] {null});

I found the problem... it wasn't that it was too large of a "dataset" for sql to handle as XML.

In this report, we are literally building an XML string of...

Add an extra row (detail or group as appropriate). Just don't put any fields in it. Watch out for the data wrapping across pages.

I like this. But if I'm reading this right, the logic is reversed.

Shouldn't it be:

Fields!Age.Value >= CInt(Parameter!AgeRange.Value / 1000) and Fields!Age.Value <= Parameters!AgeRange.Value Mod 1000?

the CInt(AgeRange/1000) returns 18; the...

Do you happen to have an example of doing this from a report?

Michael Earl (6/12/2008)

---

That is one way. I remember seeing an article on this subject recently, but I...

Okay, I found it.

On the item that toggles the visibility, on IT'S visibility tab you can set it's initial appearance of the toggle icon to [+], [-], or use an...

If you want people to help you with this, I suggest you read:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Your post as is has way too many questions about the data structure to be able to answer...

Aswanth (5/29/2008)

---

I'm Using Asp.Net with C#..

i'm having One ListBox control in which I'm getting Data Dynamically.. I want to Insert the Selected data (or ALL DATA) from ListBox Control into...

prasukj (5/29/2008)

---

hi

i am Prasanna

I have a excel source (only one excel , having many sheets )

,, in that source we find many sheet, each sheet is having data

so i...

Great article.

One of the things I've always said is that we are already working remotely on the databases... the database doesn't know if the user is in their office,...