Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to load a table to QV but exclude rows where column A = 'X'. What is the syntax for this? I thought I could just add a WHERE statement but can't find the correct way to do this. Here is my code currently:
SQL
SELECT *Let me know if that is not clear. Thanks.
Craig
HI
Table1:
Load *;
SQL
SELECT *Then store inqvd;
Store Table1 into TableName.qvd(qvd);
Then use qvd.. Because inorder to avoid the connect the database for every time. For qvd , its easy to load when compare to sql connection(data retrieval).
Hi,
You can straight away use where condition in SQL query. Please check below query
TableName:
SQL SELECT *
FROM CIA.dbo."CU_Prem_Mbrship"
where A = 'X';
Hope this helps you.
Regards,
Jagan.
How do you do A NOT = 'X'?
Thanks
Where A <> 'X'
Hi,
Try like this
where A <> 'X'
Regards,
Jagan.
Hi
Try like this
SQL
SELECT *Hope it helps
Hi Mayil,
I have the where statement figured out but still trying to understand why you advocate saving my tables as qvd. Will this improve processing time within the application (pivot table calculations when filtering)? Will this save space?
Thanks
HI
By using connection string, every time data fetch from database(sql). so its take time to load the data when compare to qvd. So only i mentioned like that..
Hope attached file helps you to understand about qvd.