General Question about Script

[ivandrago]

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

[Anonymous]

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;