Ah! Thank you Flo, much appreciated!

Thanks for the response Flo.

I now have a different problem with the output value! I am calling the sp using the following:

declare @ID uniqueidentifier

exec dbo.Add_Header @ID, 'A','B','C','D','E'

select @ID as ID

The...

Thanks all for your responses.

So would it be advisable to use a schema as well i.e. create a schema and then associate it to a custom database role? I want...

Thanks Roy

Roy, probably a dumb question but how do I create a group??

Clive Strong (1/30/2009)

---

Hi,

You are correct. This is an ownership chain issue. You will need to grant select permissions on the objects in the production data.

Also, with regards to...

PaulB (1/30/2009)

---

In my understanding you do not have a reporting database. A reporting database means you are taking a snapshot of production to separate "production" from "reporting" workload.

If I...

Great! Thanks Seth.

Hi,

Yes, that's exactly what I'd like to return.

Thanks

Michael Earl (11/24/2008)

---

The rendering in BIDS is sometimes a little different. Gaps like you are describing are often just mis-aligned controls. Make sure you don't have something a...

Michael Earl (11/24/2008)

---

The rendering in BIDS is sometimes a little different. Gaps like you are describing are often just mis-aligned controls. Make sure you don't have something a...

Nuts (11/23/2008)

---

Hi Guys

I created a temp table in Management studion and when I try to access this temp table through BI using select * , it gives an error saying...

Sergiy, amazing! Can you explain how it works though?! In the past I've used ISNULL...

vivets (11/3/2008)

---

Initialize the PeriodArray Variable with blank ('')

Further, why are you using a cursor? I think you could relatively easy refactor into a funtion, which has far better performance that...

Garadin (10/18/2008)

---

Agreed, and the Month name being entered into an alternate table to signify that real data should be used adds another unnecessary step. Add your projected data to...