bill
Sat Jul 05 14:30:22 CDT 2003
Alex,
Thank you for your reply. You're correct in that I was not specific enough in
my question. I am going in the direction of your #2 below.. We'll see....
Thank you,
Bill
bill@2burkes.com
In article <be7767$nkm$03$1@news.t-online.com>, Alexander says...
>
>on 04.07.03 21:05 Bill wrote:
>> Hello,
>>
>>I am in the early stages of writing a script that will query a database and then
>> create an Excel spreadsheet. Does WQL support "Select UNIQUE" ? If not, is
>> there a way to select unique records in a database using VBScript?
>>
>> Your suggestions are appreciated.
>
>Do you speak a) of the WMI-Query Language 'WQL' or
>b) of regular Database-Queries using SQL with a
>Database-Interface like ADO or ODBC and a provider
>like MS-SQL, Access?
>
>#if a) == true:
>
>I am not very deep into WQL but afaik it only supports
>a rather basic subset of SQL-Operators and as far as i can see
>SELECT UNIQUE and/or SELECT DISTINT is not part of this
>subset. Maybe you have a look to the WQL-Reference and see if you
>find something that best suits your intentions.
>
>
http://msdn.microsoft.com/library/en-us/wmisdk/wmi/sql_for_wmi.asp
>
>#elif b) == true
>
>Depending on the Provider (MS-SQL, Access) ADO supports a
>lot of SQL-Statements including SELECT DISTINCT|DISTINCTROW
>and so on. It really depends on the kind of Database and
>provider, what kind of queries you may perform.
>
>#endif
>
>--
>Gruesse,
>Alex
>