Ed Wagner (12/8/2015)

---

Sean Lange (12/7/2015)

---

Alan.B (12/7/2015)

---

Sean Lange (12/7/2015)

---

As of today I have only taken 4 days of PTO this year. REALLY looking forward to taking the family to Disney world...

Using the fine sample data from SQLBill.

There is no need for looping here at all. RBAR will kill this kind of thing. We can use some window functions to...

You are quite welcome. Once you understand how that splitter works you will need to also understand how to do a crosstab. Assuming you always have 4 columns you do...

joshdbguy (12/7/2015)

---

I'm looking to parse out a string into separate fields and I'm looking for a good solution to do this. Here's the example dataset,

CREATE TABLE DATA ( DATA1 varchar(50)...

Not sure exactly what your answer is here. Do you need to maintain those characters other places in the string?

Alan.B (12/7/2015)

---

Sean Lange (12/7/2015)

---

As of today I have only taken 4 days of PTO this year. REALLY looking forward to taking the family to Disney world later this week. My...

SQLJocky (12/7/2015)

---

I'm trying to get SSMS to "automatically" open the solution every time I click the icon. If there is no other way then I suppose I could just...

SQLJocky (12/7/2015)

---

I'm trying to figure out how to open a default Solution in SSMS. I have all my scripts saved into multiple projects and those are in a single...

tarr94 (12/7/2015)

---

Hi Sean. Thanks for responding.

After some more digging, I realize I no longer have a need for question #1. I've updated the initial post to reflect this....

As of today I have only taken 4 days of PTO this year. REALLY looking forward to taking the family to Disney world later this week. My wife's company holiday...

Luis Cazares (12/7/2015)

---

Sean Lange (12/7/2015)

---

Sergiy (12/6/2015)

---

And only on certain versions of CQL...

tarr94 (12/7/2015)

---

Hi,

I have a varchar column, DeliveryAddress, which, due to user-entry issues, occasionally ends up with values that have special characters at the end of it. This becomes a...

Sergiy (12/6/2015)

---

And only on certain versions of CQL Server.

Microsoft SQL Server 2008...

Definitely a good start to the week when I get one of Hugo's questions correct and I was pretty confident about my answer. Another great question Hugo. Thanks.

rwahdan1 (12/4/2015)

---

Hi,

I am new here, i make the tables in sql server and the forms in access 2007. when i did that i was using local connection (within my computer),...