I would like to get something like this .
+-----------+-------+------------+------------+
| Prod name | Desc | QtyonOrder | QtyinStock |
+-----------+-------+------------+------------+
| Coms  | Sheet |       123...

I would like to get something like this .
+-----------+-------+------------+------------+
| Prod name | Desc | QtyonOrder | QtyinStock |
+-----------+-------+------------+------------+
| Coms  | Sheet |       123...

Does it help?

CREATE TABLE mytable(
 ProductName  VARCHAR(7) NOT NULL PRIMARY KEY
,Description  VARCHAR(20) NOT NULL
,SalesOrderNumber INTEGER NOT NULL
,QtyInStock   INTEGER NOT...

Hi J Livingston,
Do you think I should remove it from here and post it on 2008?
I just don't want to upset the admin.

I am using sql 2008 R2 standard .

SELECT DISTINCT Product.ProductName,LEFT(ProductDescription, 30 

Periodend and period start are datetime as well and I have changed as you suggested earlier

AND (cast(view_SalesForecast.PeriodStart as date) >= '20160101')

AND (cast(view_SalesForecast.PeriodEnd as date ) <= '20161231')

AND (cast(view_SalesStatistics.TransactionDate as...

You have solved my problem Sir. The user gave me half information as well to compile the report but thanks to you I have got my answer I needed.

Thanks,

I have used this

dateadd(dd, datediff(dd, 0, getdate()), 0) and other but somehow it does not display the data but it shows the column.

when I use

DATEADD(dd, DATEDIFF(dd, 0,...

Thanks Mr Livingston. I got the link working now.

My query runs ok without any error but it does not show any data.

I am not getting any data when I add 2015 and 2016 line as it carries on for 3 minutes and then I cancel the query.

I am not 100% sure...

Thanks Luis, But I am not getting right numbers for 2015 and 2016 as we need to get for the whole year rather than getdate() or today. I hope I...

Hi ,

Sorry and I am grateful for your help and something I have never understood about aggregate probelm

SELECT

ca.AccountNumber , CompanyName, Value,

SUM( CASE...

Thanks Luis,

I managed to change and get this working so far

"ELECT

CompanyName, CustomerAccount.AccountNumber ,

SUM( CASE WHEN YEAR( DateEntered) = YEAR(DATEADD(YY, -4, GETDATE())) THEN (SalesLine.OrderQuantity*SalesLine.SellingPrice /...

I have got one question as I have only got read access to use this query.

I am still unable to figure out what is in the article that I need to provide.

You can call me dumb and verrrrrrryyy dumb.

May I ask another way? I have...