notifications 61467 (11/19/2014)

---

I am wondering what the difference is between essentially the same code running in a query editor window vs. calling the stored procedure that uses the same code...

DSNOSPAM (11/19/2014)

---

Yes, looks like I'm back to stored procs.

What I need to do is join some tables and return the results.

But can I use the results of a...

Matt Miller (#4) (11/19/2014)

---

Sean Lange (11/19/2014)

---

DSNOSPAM (11/19/2014)

---

Thanks Luis.

I've been reading about possible performance hits. However, this is in a reporting/analysis environment, not on a production server, and it would...

Here is yet another way...

with LegacyData (LegacyDate) as

(

select '0980412' union all

select '1100323'

)

select *

, cast(case left(LegacyDate, 1) when 0 then '19' else '20' end + SUBSTRING(LegacyDate, 2, 2) + SUBSTRING(LegacyDate,...

sqlquery29 (11/19/2014)

---

Hi ..

We are migrating data from old DB2 systems to sql server 2012, the DATE FORMAT in those systems is in decimal format with 7 digits. CYYMMDD format.

I need...

DSNOSPAM (11/19/2014)

---

Thanks Luis.

I've been reading about possible performance hits. However, this is in a reporting/analysis environment, not on a production server, and it would be less of a consideration,...

shree_z (11/19/2014)

---

I have a table with week 1 to week 52 columns that holds data for no: of days worked in each week per employee.

In SSRS I want these...

cphite (11/19/2014)

---

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...

No need to apologize at all. I let you know they are there to make things easier for you. 🙂 Unlike some other online places we try to be nice...

Igor Micev (11/19/2014)

---

Sean Lange (11/19/2014)

---

Igor Micev (11/19/2014)

---

Sean Lange (11/19/2014)

---

Great question on a great topic that many people don't know about.

It makes sense if you think about it. How would...

Hi and welcome to the forums. Let's start with some formatting so we can read this. If you use the IFCode shortcuts on the left side when posting you can...

Igor Micev (11/19/2014)

---

Sean Lange (11/19/2014)

---

Great question on a great topic that many people don't know about.

It makes sense if you think about it. How would the 208 database know...

Koen Verbeeck (11/18/2014)

---

Great, so you just copy pasted a response from Celko. Now I...

Koen Verbeeck (11/14/2014)

---

Jason-299789 (11/14/2014)

---

Koen Verbeeck (11/13/2014)

---

The CTE should be followed by a SELECT, INSERT, UPDATE or DELETE statement, not by an IF statement.

ps: the semicolon is a statement terminator, it...

No need to kill yourself doing research. Jeff Moden has written two excellent article on this very...