What a truly bizarre result set you need. You have to return the data in three different types of ways?

Can you post some ddl and sample data? I think you...

No the query that Lynn posted has nothing to do with when the value was created. It is...

Glad you were able to figure it out. It is customary around here to post your solution so that other stumbling across this thread in the future...

jasona.work (1/27/2014)

---

I'm working on creating a query to run through a series of privilege checks required by my employer. They require that we meet all the DoD STIGs for...

Matt J (1/27/2014)

---

Hi Sean,

Apologies for the lack of detail, getting what I'm trying to achieve into words is always a struggle.

It's occupied bed data that's downloaded, it has a start...

Since you are brand new around here you probably don't know that we like to see ddl and sample data in a consumable format. Something like this.

if OBJECT_ID('tempdb..#People') is not...

PIVOT will work but I find that cross tabs are easier to read and understand. They also have the benefit of...

Matt J (1/27/2014)

---

Hi,

On a monthly basis we're downloading a dataset from one of our systems and then processing it so that a record is created for each date between the...

Hi and welcome to the forums. What you are describing is known as a cross tab or pivot. There are 2 articles referenced in my signature that explain how to...

--EDIT--

It is Monday morning and I misread this post entirely. Need more coffee.

Not really sure why you want to take nicely normalized information and smash it all together but this is actually fairly easy to do. Please see this article that explains...

rani_sals (1/25/2014)

---

Oh okay!

Well now to call this SP for UI, I use this below code.. but what do I have to pass as the tvp object parameter, to enter the...

rani_sals (1/24/2014)

---

Thanks. So I tried this code, but it gives me error saying I must declare @TrainerID,, when I've already done that.

That is pretty close. Remember that your user defined...

Is the mdb file readonly?

You can read about them here. http://technet.microsoft.com/en-us/library/bb510489.aspx

The basis gist of it is that you first create the type, then...