MadAdmin (4/7/2015)

---

Read committed also has it's issues.

It is possible to read the same row twice with read committed, once before a change, then after the change.

All isolation levels have issues...

Your splitters are almost certainly the issue here. They need to come to a quick and painless death immediately if not sooner. Looping in...

djacobos (4/7/2015)

---

I posted my splitter function Above.

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

My understanding was that instead of doing a NOLOCK on each table this would apply to the entire...

Can you post your splitter function? That may very well be the culprit of the performance issues.

Also, I noticed you are using the isolation level read uncommitted. Are you aware...

Hi and welcome to the forums. This can be done, even dynamically. Take a look at the articles referenced in signature about cross tabs, especially the second one about dynamic...

pmcamilleri (4/7/2015)

---

This application was written in Visual Dataflex 17.1 and we installed their SQL Connectivity Kit on the user's workstation in order for him to be able to connect to...

pmcamilleri (4/7/2015)

---

Thanks for replying. When I remove the System DSN and try to launch the application I still get the same error message.

When you say connect directly, how can...

Why are you using a system DSN to connect here? Why not just make a direct connection and skip the system DSN.

below86 (4/7/2015)

---

Sean Lange (4/6/2015)

---

Why do you need to use dynamic code here? I see that you have a list of values in your variable but if those were broken out...

sunitkrishna (4/7/2015)

---

...

In my result set a few designations don't have values for any of the projects(These designations are not the same always).Currently I have replaced NULL with '0',but what...

mballentine (4/6/2015)

---

The reason I am asking is because our customer has requested to be able to view the movie that is associated with the data in the database. As far...

mballentine (4/6/2015)

---

I have a database and a dvr that has movies that correspond to the data in the database. Is there a way to run a report and then by...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

Why do you need to use dynamic code here? I see that you have a list of values in your variable but if those were broken out you wouldn't need...

What have you tried? It looks like you have already written the case expression you need. Just put it in as a column. In the meantime you really need to...