Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am able to build a parameter based query. I want to substitute the
parameters by using Cell references in the query. I looks like I must add on parameter for each cell in a column. The query needs to process 200 parameters at a time. Is there an easier way to configure this? Current dqy file looks like this: XLODBC 1 Description=xxxxxx Lab;DRIVER=SQL Server;SERVER=xxxxxx;UID=UGS;APP=Microsoft® Windows® Operating System;WSID=PTLLG3L7C91;DATABASE=xxxxx SELECT jc_test2.Access, jc_test2.Access_Type, jc_test2.Computer, jc_test2.GroupDomain, jc_test2.GroupName, jc_test2."Resource Type", jc_test2.USERDomain, jc_test2.USERName FROM Altiris.dbo.jc_test2 jc_test2 WHERE (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) OR (jc_test2.USERName Like ?) usr001 usr002 usr021 usr003 usr004 usr005 usr006 usr007 usr008 usr009 usr010 usr011 usr012 usr013 usr014 usr015 usr016 usr017 usr018 usr019 usr020 usr025 usr026 usr027 usr028 usr029 usr030 usr021 usr001 usr002 usr021 usr003 usr004 usr005 usr006 usr007 usr008 usr009 usr010 usr011 usr012 usr013 usr014 usr015 usr016 usr017 usr018 usr019 usr020 usr025 usr026 usr027 usr028 usr029 usr030 usr021 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 -9 Access Access_Type Computer GroupDomain GroupName Resource Type USERDomain USERName |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Criteria using "Or" and parameter query | Excel Discussion (Misc queries) | |||
Get External Data - not editable using Query Wizard | Excel Discussion (Misc queries) | |||
Query parameter "refresh when value changes" doesn't refresh - why | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) |