Please Look at this query
  Home FAQ Contact Sign in
Search only in:
uk.politics.misc
 
 Advanced search
MATCHING GROUPS



more...
Group Profile...
POPULAR GROUPS

more...
found 14201 articles for 0.335 sec
Re: Help me for these sql line case please     

Author: Jason Lepack
Date: May 14, 2007 22:03

... other. You could implement a Cartesian join but I don't think that the result of that is what you are looking for... Actually, on further inspection, it may be what you want, so here it is, if it's not,... in SQL View (View -> SQL) in a new Query: SELECT FieldA1, FieldA2, FieldB1, FieldB2,... AS FieldD1 FROM Table_A, Table_B, Table_C Please note that this query will return 4*5*7...
Show full article (2.42Kb) · Show article thread
Computer Science Thursday, May 10, 2007: The Impact of I/O Cost Models on Database Query Optimizers     

Author: wlrush
Date: Apr 27, 2007 21:17

...been scheduled: The Impact of I/O Cost Models on Database Query Optimizers In this study, we try to characterize quantitatively the ...the optimizer of a Database Management System (DBMS). The cost of a query execution plan depends not only on the number of... cause larger errors. Date: Thursday, May 10, 2007 Time: 13:00 Please look on WebCalendar to view this appointment. http://www.cs....
Show full article (2.15Kb)
Re: Query link to Form (Date Range)     

Author: John W. Vinson
Date: Apr 23, 2007 04:27

... - Total: 1,500 *Link to the Forms I should have all three queries should be the same as 1,500. Is there a reason for that or date format problem ? Yes; presumably there is something different with the queries. We cannot help you identify the difference between the ...* us the queries. Please open the queries in SQL view and post the SQL text here. If you look at the query ...
Show full article (1.15Kb) · Show article thread
RE: query an Excel file using Query Analyzer     

Author: Ed
Date: Apr 10, 2007 03:50

Yes. Please look at Openrowset / Openquery in BOL Ed "Eric Bragas" wrote: Hi All, Is it possible to query an Excel file using Query Analyzer? For instance, I need to know the sum of column A in "c:\myfile.xls". Can I get this value using Query Analyzer without having to physically open the file and sum the column myself? Thanks, Eric
Show full article (0.37Kb) · Show article thread
Re: query assistance - combine two into one     

Author: xiangyuanbo
Date: Mar 14, 2007 02:51

you can use UNION ALL SELECT, for more details please look up at BOL:) -- xiangyuanbo ------------------------------------------------------------------------ xiangyuanbo's Profile: http://www.xpertgurus.com/member.php?userid=351 View this thread: http://www.xpertgurus.com/showthread.php?t=198543
Show full article (0.30Kb) · Show article thread
Re: Tables missing when querying using query analyzer     

Author: Garth
Date: Feb 27, 2007 15:46

... to query Add/Remove program data. Using query analyser i only found the Add_Remove_Programs_Data table which does not have a ResourceID Column while when i look at the query statement created by SMS Management console it has a table called SMS_G_System_ADD_REMOVE_PROGRAMS which has a resource id column. Where do i find this table. Please help. Thanks, Chetan
Show full article (0.68Kb) · Show article thread
Tables missing when querying using query analyzer     

Author: chetanh
Date: Feb 27, 2007 15:08

... to query Add/Remove program data. Using query analyser i only found the Add_Remove_Programs_Data table which does not have a ResourceID Column while when i look at the query statement created by SMS Management console it ... a table called SMS_G_System_ADD_REMOVE_PROGRAMS which has a resource id column. Where do i find this table. Please help. Thanks, Chetan
Show full article (0.45Kb)
Re: From code directly open query     

Author: fredg
Date: Feb 25, 2007 04:26

... Not when the code is running ... but... if I am programming code or reviewing code and I need to look at the query design I was thinking maybe I can highlight the query name and hit a...> among all the other queries in the query tab. Thank you, Steven No. Code does not work that way. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
Show full article (0.56Kb)
Re: please help with distinct query ...     

Author: Erland Sommarskog
Date: Feb 18, 2007 00:50

... an MS SQL table that is designed to serve as a transaction log. I want to query this table to return the last record (Max(date) ?) ... thing in parentheses is a derived table. Sort of a temp table within the query, but only logically. It's never materialised, and SQL Server is often able to recast the query so it is computed more efficiently than it may look. -- Erland Sommarskog, SQL ...
Show full article (2.23Kb) · Show article thread
Re: Combo Box Query     

Author: fredg
Date: Dec 16, 2006 17:18

... to return all stores for them. How can I accomplish having my combo box look at the query and still allow a user to see all stores if... by StoreID; Code the event used to open the query, i.e. a Command Button click event ... will be returned. If you enter <All> all records will be returned. -- Fred Please respond only to this newsgroup. I do not reply to personal ...
Show full article (2.54Kb) · Show article thread
3 · 4 · 5 · 6 · 7 · 8 · 9 · 10 · 11 · next