Jeff Moden (8/3/2008)

---

Perfect... with the idea that the running total may not be for consecutive ID's, would you mind posting the formula for the computed column and the view with...

Jeff Moden (8/3/2008)[hrSecond idea sounds good to me. Will the report return the columns named in the NVP table horizontally automatically and in the correct order? I ask...

I probably wouldn't use a dynamic SQL approach, because that is going to be much harder to work with on the report side anyways. How are you going to...

Animal Magic (8/3/2008)

---

Hi Jeffrey,

Ive slightly complicated matters here. there are a few areas where i have been looking to implement triggers, most are for email reasons, in which case...

Did you change the account that is running SQL Server? For example, change from a domain admin account to a domain service account? Or, from local system to...

Jeff Moden (8/3/2008)

---

Sorry, was in a hurry. I should have posted them (more than 1) without even being asked.

There are a couple of ways to do it... the method...

Animal Magic (8/3/2008)

---

Many thanks for the detailed reply, at least now i understand why that message is appearing after the update statement from the application. I couldn't work out...

JKSQL (8/1/2008)

---

Both those scripts look good but I have a few problems.

The user using the sp will not have permissions to alter a table. So I can not disable...

rbarryyoung (8/1/2008)

---

I cannot think of any way that you can do this, without installing some software or service on the remote server. I think that you will have to...

I really don't have an answer to your specific question, but have you tried enabling the SQL Browser service on ServerA? That service should allow you to reference the...

Deee -Daah! (8/1/2008)

---

Hello,

When I use COALESCE to concatenate a string over many periods, it gave me the string backwards.

--using the table #test as is, gives me the results backwards...

alorenzini (8/1/2008)

---

Actually that last statement worked fine but in order to get it functional I need to add it into my WHERE Clause then I can just get rid of...

alorenzini (8/1/2008)

---

The @Level paramters are passed into the proc by the user. they can display which levels they want the proc to return. Each @level is a bit field.

I tried...

IF (@Status = 'All active')

BEGIN

SELECT *

FROM #DLFiltered...

Art, all you needed to do was add parantheses around the bolded section to 'pair' those two criteria. That should fix the issue you have with that dynamic query.

BTW...