neglect code from database

[Anonymous]

Hi Al,

This is my table in database and I am getting blank data in my chart as for certain items(circled in black) I dont have goadssender (its a primary key ie itemcode in a table ) so I want to neglet those items what query should i use in table to neglect those records ?

Increment_Sales:

LOAD  GoodsSender,

     InvoiceNumber,

     CreateDate,

     ItemNumber,

     InvoiceQuantity,

     SalesPrice,

     LocalAmount,

     VatAmount,

    Walkins;

SQL SELECT *

FROM ETPEASV55.dbo."VW_CashOrderTRN1"

//WHERE InvoiceType = '31' and (CreateDate >= 20150101 and CreateDate <= '$(currentdate)') ;

WHERE InvoiceType = '31' and CreateDate >='20150101' and CreateDate <= convert(nvarchar(8),getdate()-1,112);

store Increment_Sales into C:\Users\dmsadmin\Desktop\QlikView_UCB_Report\QVD\extract_qvd\Increment_Sales.qvd;

drop table Increment_Sales;

[shiveshsingh]

You can ignore those ids in where clause

[Anonymous]

how?

[shiveshsingh]

where ID <> 'IDs to be removed'

[sasiparupudi1]

My be try

SQL SELECT *

FROM ETPEASV55.dbo."VW_CashOrderTRN1"

//WHERE InvoiceType = '31' and (CreateDate >= 20150101 and CreateDate <= '$(currentdate)') ;

WHERE InvoiceType = '31' and CreateDate >='20150101' and CreateDate <= convert(nvarchar(8),getdate()-1,112)

and GoodsSender is not null;