|
Hi,
However i had already shared the structure of file1 in my earlier post also
shared SQL queries on file1 and view (V1) created on it , also i had shared
how i had joined other files to form this file1,,may be it might have been
not getting displayed properly due to some format issue while posting in my
earlier posts.
Please find all these SQL queries and the file1's structure ( main physical
file (file1) on which view v1 was created and sql query was formed ) in
the below midrange link.
https://code.midrange.com/edb5db827f.html
I was able to execute all these SQL queries without any typo error ,please
help to let me know the reason for the different record counts for main
file1 and in the view created on it for the same dates selection criteria.
*Note* - What is the reason to do this calculation like -(field1* 1000000)
+ ( field2*10000) + (field3*100) + field4) for all these fields , I mean
how is this calculation has been done, could someone please elaborate it
here ( so that it form as CCYYMMDD) ?
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.