narayanamoorthy.a (6/28/2016)

---

Yes ID column is primary key and ID_TASK_USER is foreign key with unique identifiers. Below is the script

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[task_attach](

[id] [uniqueidentifier] NOT NULL,

[id_task_user] [uniqueidentifier] NOT...

Both columns?

Please post CREATE TABLE scripts for both tables.

What is the datatype of the two columns in the join?

...id_task_user in (select id ...

Ed Wagner (6/27/2016)

---

ChrisM@Work (6/27/2016)

---

Beatrix Kiddo (6/27/2016)

---

GilaMonster (6/26/2016)

---

Hugo Kornelis (6/26/2016)

---

I like the sentiment, but I don't think there is any realistic chance of this having any effect. The votes have been...

Does the code execute successfully in SSMS?

select count(*), avg(datalength(embedded_data)) from task_attach where id_task_user in (

select id

from task_user

where task_type = 1 and [status] =7

and date_begin >= CAST(CAST(DATEADD(DAY,-180,GETDATE()) AS DATE)...

Newbi (6/28/2016)

---

It will b better of with looking up UNION and UNION ALL first.

I really am not aware of importance of order in group by. Those are not intentionally...

Newbi (6/28/2016)

---

Sorry for all the confusion.:crying:

This is the final query which I make consistency in naming the columns.

Select * from

(SELECT Zone,ItemName, ItemCode, Quantity, GrossWeight

FROM ...

Newbi (6/28/2016)

---

After changing the order of group by in inner query ,now it is running ok. But it is still showing error: Conversion failed when converting the varchar value 'TotalQ'...

Newbi (6/28/2016)

---

After changing the order of group by in inner query ,now it is running ok. But it is still showing error: Conversion failed when converting the varchar value 'TotalQ'...

SELECT

NewColumn,

[Old] = MAX(CASE WHEN ItemState = 'old' THEN [Stuff] ELSE NULL END),

[New] = MAX(CASE WHEN ItemState = 'new' THEN [Stuff] ELSE NULL END),

[Used] = MAX(CASE WHEN ItemState =...

The inner query has errors. Work on it in isolation from the whole query.

SELECT Dept, IName, ICode, Quantity, GrossWeight

FROM Data_Details

UNION

SELECT Zone, ICode, IName, SUM(Quantity) AS TotalQ, SUM(GrossWeight) AS GrossWt...

Are you by any chance attempting to perform a pivot or unpivot (rows to columns or vice versa)? If so, there may be alternative methods which are a) "standard" and...

Beatrix Kiddo (6/27/2016)

---

GilaMonster (6/26/2016)

---

Hugo Kornelis (6/26/2016)

---

I like the sentiment, but I don't think there is any realistic chance of this having any effect. The votes have been counted; the results...

jasona.work (6/24/2016)

---

ChrisM@Work (6/24/2016)

---

Eirikur Eiriksson (6/24/2016)

---

Luis Cazares (6/24/2016)

---

I'm sorry, is there any country that can give me good news? It seems that Mexico, US and UK are full of negative news...

Eirikur Eiriksson (6/24/2016)

---

Luis Cazares (6/24/2016)

---

I'm sorry, is there any country that can give me good news? It seems that Mexico, US and UK are full of negative news and I'm...