General Question about Script

ivandrago — Thu, 25 Nov 2010 00:46:38 GMT

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

General Question about Script

Anonymous — Thu, 25 Nov 2010 02:05:48 GMT

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;

topic General Question about Script in QlikView

General Question about Script

General Question about Script