djj (5/10/2016)

---

Sean Lange (5/10/2016)

---

ChrisM@Work (5/10/2016)

---

Sean Lange (5/9/2016)

---

So I brought back some yummy foods from New Orleans. I got some crawfish and pork sausage, some gator and pork sausage and a...

jaggy99 (5/10/2016)

---

I have joined the calendar table and vacant table but it returns a single row where it should return two rows one for Jan vacant days and Feb Vacant...

That answers my first question.

The bigger question though is what do you expect for output from your sample data?

Welsh Corgi (5/10/2016)

---

When I execute sp_helptext on a Stored Procedure it returns that there is no text for object on a Stored Procedure.

How can I grant read permissions to a...

jaggy99 (5/10/2016)

---

Hi,

I'm trying to calculate the property vacancy rate per month which is no of days a property is vacant in a month x the no of vacant properties. Below...

ChrisM@Work (5/10/2016)

---

Sean Lange (5/9/2016)

---

So I brought back some yummy foods from New Orleans. I got some crawfish and pork sausage, some gator and pork sausage and a couple gator fillets....

You just got your point....now if they were only worth something.

Oh lordy....here is a discussion on another forum from earlier today.

OP:

My SQL update string looks like this: "UPDATE " + tableName + " SET ??? = " + "'" +...

So I brought back some yummy foods from New Orleans. I got some crawfish and pork sausage, some gator and pork sausage and a couple gator fillets. This was all...

anjaliagarwal5 (5/6/2016)

---

I am not looking for splitter function. I am also looking for update statement that will update two other tables table 2 and Table 3 based on the ID...

anjaliagarwal5 (5/6/2016)

---

Hi All,

I need to update two tables based on the third table ID. I am passing an ID of table 1 from my code as string with comma...

Oh great...now we all have more points than we deserve since...

sindhupavani123 50704 (5/6/2016)

---

I have written a query using pivot and the data is correct like how I want( This excudes grouping).

Data :

id desc Color colorid...

tripleAxe (5/6/2016)

---

Sean Lange (5/6/2016)

---

tripleAxe (5/6/2016)

---

I agree. I don't undertand why some peoples get so...

Ed Wagner (5/6/2016)

---

Sean Lange (5/6/2016)

---

tripleAxe (5/6/2016)

---

I agree. I don't undertand why some peoples get...