Ray K (5/16/2016)

---

djj (5/16/2016)

---

Eirikur Eiriksson (5/16/2016)

---

GilaMonster (5/16/2016)

---

jasona.work (5/16/2016)

---

Somedays, I envy you folks living in places that don't have "weather" like what we've had these past couple weeks...

Last weekend, we had...

What Jeff said.

It's quite a big jump from concatenating strings to calculating days in a fiscal year. A calendar table of some description will certainly make things easier.

smer (5/16/2016)

---

Hi All,

how to modify the fiscal year sqlquery to works in 2008r2?

SELECT

CASE WHEN MONTH(service_date)>=7 THEN

concat(YEAR(service_date), '-',YEAR(service_date)+1)

...

hlsc1983 (5/10/2016)

---

i have a table MARKS with the following columns:

Studentid int as foreign key ,

Subjectid int as foreign key,

Grade int,

Gradetype int as foreign key,

Grade_pk int as primary ke

A subject can...

ChrisM@Work (5/10/2016)

---

BLOB_EATER (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 couple...

Reported as spam

Reported as spam

I could have been at Bits but oh no I had to go to the party.

Felix Pamittan (5/5/2016)

---

Correct answer:

Yes, you can run this code, This returns 97

Explanation:

You can run this code. The CHAR variable is converted to NCHAR and the first character's value...

We've got a problem with entities having different names across different teams in the same business. To compound the issue, tables in the data warehouse have the same names...

AARGH! Session timeout!!...

Grant Fritchey (4/27/2016)

---

Steve Jones - SSC Editor (4/27/2016)

---

tindog (4/27/2016)

---

I'd love to go to this, but have no SQL-y friends and get v anxious in unfamiliar places where I don't know...

That was surprisingly easy for one of Andy's questions. There weren't any tricks or things that we should have inferred from the position of a comma :cool:. I...

Steve Jones - SSC Editor (4/26/2016)

---

BWFC (4/26/2016)

---

I'm now unregistered as yesterday I was officially invited to spend my Saturday afternoon with an army of four-year-olds on a sugar-rush. Although...

NineIron (4/26/2016)

---

I have a report with too many columns to fit onto a landscape format. Is there a way to "divide" the record up to create two rows for the...