I have several hundred reports that I maintain over various systems... many of them based on one or more stored procedures, many others with one or more SQL scripts...

GilaMonster (11/15/2014)

---

Simplifies the parser, makes it easier to extend the language. T-SQL's getting to the point where it's hard for the parser...

Ed Wagner (11/14/2014)

---

GilaMonster (11/14/2014)

---

Jason-299789 (11/14/2014)

---

Gail/Lynn/Ed,

I don't disagree, and as Lynn states maybe if MS enforced it so that code wouldn't compile without the use of the statement terminators, like they...

Yeah, I saw that but that site is notorious for not following up on issues, and it...

Alan.B (9/11/2014)

---

Sean Lange (9/11/2014)

---

Alan.B (9/10/2014)

---

months as

(

select 1 as MoNo, 'January' as Mo union all

select 2 as MoNo, 'February' as Mo union all

select 3 as MoNo, 'March' as Mo union...

michaeleaton 36224 (9/10/2014)

---

Hey, so I have the following SQL Query:

SELECT COUNT(DISTINCT CustomerID) AS ActiveCustomers, DATENAME(MONTH, PaymentDate) + ' ' + DATENAME(YEAR, PaymentDate) AS [Period]

FROM dbo.[Order]

WHERE DATENAME(YEAR, PaymentDate) > 2012

GROUP BY...

jcrawf02 (9/4/2014)

---

Ed Wagner (9/4/2014)

---

Koen Verbeeck (9/4/2014)

---

andrew gothard (9/4/2014)

---

You know Chris Date?...

SQLRNNR (9/3/2014)

---

Luis Cazares (9/3/2014)

---

xsevensinzx (9/3/2014)

---

Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just...

RTaylor2208 (3/17/2014)

---

One easy solution to build up a history is to script a job to run as frequently as you want to insert a tracer token, you can then...

sing4you (2/20/2014)

---

Yes, it is the correct SP name. It is getting it from the designer. The designer got it from a pick list that it created because it...

GilaMonster (2/9/2014)

---

SQL won't start in that case,...

Correct - when you restart...

wendy elizabeth (1/16/2014)

---

In an ssrs 2008 report, I need to place a 'customer short name' in a detail line when the field has a value in it. When there is...

True enough. I needed to move tempdb on our production server a few months back and even that was...

EdVassie (1/14/2014)

---

IMHO moving a system database on a test server can be a useful part of educating yourself in how SQL Server works, what can break, and what needs to...