Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I prefer writing my sql queries n T-SQL (SQL Server), when building a QVD does it matter if I generate my load using sql server and doing my logic there? i.e.
Test:
LOAD
Type,
[Order No],
[Paid?],
[Invoice Date];
SQL SELECT
b.Type,
a.OrderNo as [Order No],
case when a.PayType = 'A' Then 'Yes' Else 'No' End as [Paid?],
a.InvoiceDate as [Invoice Date]
From
TableA a inner join TableB b
on a.regid = b.regid
Where
a.invoicedate > getdate()-30;
Or should I be doing this another way? Does it effect any performance by doing the above?
Thanks
You can use SQL Server to develop you queries -> not a problem If you are connecting using odbc then you can simply get rid of the load part of your query... Try
Test:
SQL SELECT
b.Type,
a.[Order No],
case when a.PayType = 'A' Then 'Yes' Else 'No' End as [Paid?],
a.[Invoice Date]
From
TableA a inner join TableB b
on a.regid = b.regid
Where
a.invoicedate > getdate()-30;