vceklic (6/18/2015)

---

Hi everyone,

Can someone help me solve this:

I have 2 tables that look something like this:

Table Price:

id - int

price - varchar

validFrom - datetime

validTo - datetime

itemId - int

....

Table sales:

id - int

price...

Does this simplification work for you? We can add Clean and Unclean next.

SELECT

RES.method,

payment_id = SUM(CASE WHEN Filter = 1 THEN 1 ELSE 0 END),

[status] = SUM(CASE WHEN...

You will find this much easier to work with if you can reduce the clutter, and one way of doing this is to encapsulate sections of the code into other...

Hi Paul, and welcome to ssc.

Can you post the whole query please, it's generally easier to work with a whole query, there's less chance of something you haven't seen...

Are you going to post up a few examples or keep Sean guessing?

Yes, but no. If there are no parameters, you can capture...

T2512 (6/17/2015)

---

Thank you so much for the reply! I was able to reduce the time to 1 second with the following query. I am not sure why this takes 1...

j.grimanis (6/15/2015)

---

Hi,

I have a procedure which inside I call two other Procedures, the first one is updating table Purchase Order and the second one is updating an intermediary table afterPurchase...

narengc (6/16/2015)

---

Ok, Looks like I have not provided sufficient details to get some help. Just to give you some more back ground I am working on migrating oracle DB to...

TomThomson (6/16/2015)

---

sgmunson (6/15/2015)

---

syed_3177 (6/14/2015)

---

I have a right join query where i have a table where all employees attendence entry are registered and another table where pay master table.

I need a...

narengc (6/16/2015)

---

I need some help on looping through each row of Table valued parameter.

I have user defined type

CREATE TYPE [dbo].[PCS_SPEC_ATTR_VALUE] AS TABLE(

[ATTR_NAME] [varchar](256) NULL,

...

.Netter (6/16/2015)

---

Hello,

I'm no expert in SQL, I dabble here and there.

I need to create a function which takes two bigint parameters and returns true or false depending on it a...

It's a long shot without the execution plan and table...

-- Here's your query with some structural changes which I've made to

-- assist tuning.

SELECT

PPS.[No],

PPS.PID,

PPS.[Date],

PPS.Amnt1 + PPS.AMNT2 + PPS.Amnt3 - ISNULL(PPSL.Amnt4,0) + PPS.Amnt5

AS Amnts

FROM TPSTab PPS...

So if someone posts up some fantastic code for you, you're unable...