rajd2106 (12/1/2014)

---

SALES_DETAIL table contains sales_id, prod_type & Prod_price.

In this query I am trying to do aggregation from SALES_DETAIL table :

sum(prod_price) by sales_id & INSERTING into SALES_HEADER table as sales_amount.

Selecting...

This was also posted on stackoverflow. http://stackoverflow.com/questions/27232562/issue-with-select-statement-in-a-stored-procedure

Here is the real issue. We can't see your screen, we have no idea what your tables are like and we don't really know...

rajd2106 (12/1/2014)

---

Hi SQL Gurus, I am new to the SQL Programming and also new to this forum.

I have 3 tables: CUSTOMER, SALES_HEADER, SALES_DETAIL and there are no relationships / keys...

Also this looks painfully like QA in SQL 2000. Can you confirm which version of sql server you are using? The answers are going to be vastly different if you...

sqlquery29 (11/26/2014)

---

Hi Sean,

I tried writing the function

CREATE FUNCTION dbo.Convert_Date (@date_column decimal(7,0))

Returns date as begin

declare @date date

set @date = CONVERT(DATE,CASE WHEN LEFT(@date_column,1) = '1' THEN '20'

ELSE '19' END + RIGHT(@date_column,6),...

+1 voted

What are you using for this analysis and what do...

Cheryl McLaughlin-385812 (11/25/2014)

---

I have to keep the nextval due to our ERP system. This will be a job that runs once a night, so there would be no concurrency issue....

JoshDBGuy (11/25/2014)

---

All,

We have dozens of stored procs with sp_executesql inside the procs. When I run an analysis to determine long-running queries, these are acting as if they are ad-hoc. Is...

Great job posting ddl and sample data. Can you take it one step further and post what the desired output would be for this sample data? I think I get...

Yeah that thing needs a complete rewrite. Once you have nested case expressions it is good chance you can simplify. When they are nested this deep it is not longer...

MERGE has several bugs. I would avoid it. That being said it is hard to figure out exactly what you are trying to do. Could you just an identity column...

sqlquery29 (11/25/2014)

---

Hi..Thanks for the reply's

sorry for the confusion...let me be more clear..

The data is extracted to sqlserver from DB2 and date columns are in this format 'CYYMMDD' with decimal datatype.

Now...

Jeff Moden (11/24/2014)

---

Sean Lange (11/24/2014)

---

You read that document (which btw is more than 6 years old) and you...

Cool. Glad that worked for you and thanks for letting me know.