Steve Jones - SSC Editor (6/9/2015)

---

Nothing is ever simple, and the queries that do this potentially slow way down with...

tstagliano (6/8/2015)

---

We have the below query which is pulling in Sales and Revenue information. Since the sale is recorded in just one month and the revenue is recorded each...

@jeff, please can you amend your sample data set so that it contains each of the conditions you describe? Thanks. Then run this and have a look at the results....

SQL Server has the IDENTITY attribute and Sequences for this - why reinvent the wheel?

SandyTucker (6/6/2015)

---

That worked! Actually I had something like that earlier but didn't realize I still needed the =0 at the end.

Thank you so much both of you, I can't...

This is a slightly different take on Dwain's method. I'd guess they perform about the same.

WITH SampleData (NAME, D1, D2, D3, D31) AS

(

SELECT 'X1','9H','30M',NULL,'10M'

...

nie mouse

spectra (6/4/2015)

---

Ok. not an issue. Is it possible to write this in pure SQL way ? (so that I don't face database migration issue later)

My query works...

Dan121 (6/4/2015)

---

All I am asking is simple questions. Please forget what I am trying to accomplish or what I am trying get.

After running below query (AdventureWorks database). I get...

In SQL...

CASE

Jason A. Long (6/4/2015)

---

It was just a rewrite of the original code Sales.Customer code.

I didn't like...

spectra (6/4/2015)

---

Could you please tell how do I optimize this SQL query ? ( I am using MySql)

select DU.kUserId, DU.kUserName , DU.email,DU.contactNo,SID.intDtlId,SID.cbFlag,SID.pcbt,G1.gName as gen1,G2.gName as gen2 from (select...

Solution to what? 😀

ChrisM@Work (6/4/2015)

---

...

Sure. Start a new thread, and include the Actual Execution Plan as an attachment.

If you want all columns from your invoice table, your options for tuning...