Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Doing an "indirect" SQL SELECT
- Does anyone know how I can do an "indirect" SQL SELECT statement? (one in which the column to return from a table is not named explicitly, but is contained in a variable?)For example, instead of this:SELECT trailer FROM .... WHERE ...I need to be able to do something like this:DECLARE...
- Tags: ttobin100@..., SQL, SELECT @FieldName, DECLARE @FieldName nVarChar
- Discussion threads 2007-10-08
- Sql Select from Databases on Multiple MSSql Servers
- Is there a way to include the server name in an sql select statement. (E.g select ([select columns] from server1.db1.dbo.table1 , server2.db2.dbo.table2 where [where statements])if not is there any other way to achieve thisLook up sp_addlinkedserverBeen a long time but yiou can then useselect * from Link.dbo.TableWhere link = server.database.Usually...
- Tags: Programming languages, Databases, awcrichton@..., SQL, database
- Discussion threads 2007-05-16
- Select Text
- In Microsoft Office Word 2007, one can select text or items in a table by using the mouse or the keyboard. One can also select text or items that are in different places. For example, the user can select a paragraph on one page and a sentence on a different...
- Tags: Microsoft Corp., Text, Keyboards, Mice, Microsoft Word, Word Processors, Microsoft Office, Hardware, Peripherals, Office Suites, Software
- White papers 2007-12-01
- Select statment in a VB code
- Select statement is timing out inside VB program code thereby resulting to ODBC failure. However the select command is correct and the same select command is working using query analyzer from the SQLSelect Statement in a VB CodeKindly post your code and let me check that to provide u the...
- Tags: tim.oyelowo@..., IVC_DATE, software, programming, Microsoft Visual Basic
- Discussion threads 2007-02-19
- Nested Select statements
- Has anyone ever used a statement like this:Select column1, column 2, (select columnA from table2) from table1 where....?This is contrary to anything I have ever seen in SQL (especially ANSI/ISO SQL), and I would appreciate your comments. ThanksSKNo I haven't, not once in in 17 yearsmore to the point...
- Tags: Databases, shelley.kuebler@...
- Discussion threads 2007-11-19
- Sql Question
- I have a table in which I need to select only the participants who have multiple rows. I tried the group by and having count(*) > 1 but I need to display each time they are in the table but only if they are in more than one. ...
- Tags: maison.hughes@..., programming, SQL, T1
- Q&A 2005-05-05
- can anyone explain.. SELECT @ApplicationId = NULL
- DECLARE @ApplicationId uniqueidentifier SELECT @ApplicationId = NULL what does this Select do? I have to modify as procedure but don't know what this code does. i am not a dba so bear with me.Well it declares a local variable@Applicatio
- Tags: programming, software, GUID, katokato, SELECT, SELECT @ApplicationId
- Discussion threads 2006-11-10
- Select Random Line(s) From File(s) Software (exe)
- When you cannot decide on the item to select from a certain file, this application will save you. Select one or many random lines from one or many files. This software will prove to be very useful in your work. This version is the first release on CNET Download.com.
- Tags: Software, File, Tools & Techniques, Management
- Software downloads 2007-12-19
- PhotoSelector (zip)
- The easier way to select your photos to be printed. With PhotoSelector you can select your photos to be printed in only tree easy steps. Just select the files from multiple folders, set up the number of copies and their size and then make a CD copy.
- Tags: Photograph
- Software downloads 2006-04-05
- How do I?
- I am using Microsoft Outlook to catch my email. How do I view Headers or subscribe to newsgroups. Any advice would be welcome. ThanksJsaggsHeaders, yes. Newsgroups, no?To view the headers, right-click the message line in your Inbox and select Options. The headers will be at the bottom.I don't...
- Tags: e-mail, headers, jsaggs@..., Microsoft Outlook, newsgroup, newsgroups, outlook, subscribe
- Discussion threads 2006-01-12
- sql function
- how to use exec statement in udf function to excute a variable which given as select statementDo you meanDeclare @MyQuery VarChar(500)Select @MyQuery = "Select * From MyTable"Execute (@MyQuery)You have to put the parentheses in.
- Tags: software, SQL, thiyagarajan.srinivasan@...
- Discussion threads 2007-01-02
- Two copies of an email.
- In exchange Server 2003, how can you have an email sent to personONE@123.com go to personONE@123.com and personTWO@123.com without using an Outlook 2003 client rule.If your using AD, go to the user personone in AD and select properties. Then select the Exchange general tab and then select Delivery options. Use...
- Tags: E-mail, Microsoft Office
- Q&A 2004-12-09
- Select Statements with Condition
- I need some help in the SQL select statements with the condition. The select should contain something like this where:- One cust_id have many listing_id. Each listing carry status such as O and R. There are thousand's of cust_id with the status of 'O' and 'R'. If the cust_id have...
- Tags: cust_id
- Q&A 2005-10-22
- On Target for Success
- Target Group Ltd. use Select Business Solutions products Select Component Architect and Select Jsync to help them successfully build their clients' application. The client's application needed to expand access to their Credit Loan Application Process through the Internet and provide a new interface through a browser to their internal call...
- Tags: Client, Internet, Application Servers, Web Browsers, Middleware, Enterprise Software, Software
- Case studies
- How to implement Query with in a Query?
- Hi every body.I have a DB in which i am implementing a Query for Search. I am ok with it. after getting this result whatever the result of the search query is I want to further put a search criteria in the searched table. but i can not do so....
- Tags: Databases, khaksar_mkd@...
- Discussion threads 2007-09-01
- An Advanced Segregation of Duties Capability for HP OpenView Select Identity
- Segregation of Duties SoD is a critical control issue for many organizations. This white paper defines SoD, discusses the relationship between SoD and the provisioning process, introduces HP OpenView Select Identity and its current SoD capabilities, and describes an advanced Select Identity SoD prototype created by HP Labs, which is...
- Tags: Hewlett-Packard Co., HP OpenView, Identity, Segregation Of Duties, Utility Computing, It Management, It service Management
- White papers 2006-07-01
- OpenView Select Identity Web Demo and Sneak Preview
- This webcast will demonstrate the capabilities of Select Identity and the ease of setting up and removing user identities across an organization's systems and applications - including a sneak preview of our new graphical interface. If so, you are not alone and HP OpenView Select Identity can help! HP OpenView...
- Tags: Web, Hewlett-Packard Co., HP OpenView, Identity, Utility Computing, It Management, Authentication/Encryption, It service Management, Security
- Webcasts
- Deleting usernames/passwords in Firefox
- Firefox has an annoying habit of saving multiple, incorrect usernames. The most common example is when I inadvertently type my password following my username in the same box.Is there some way of deleting all these incorrect usernames?Hi,In Firefox, select Options from the Tools menu.Select the Privacy icon from the...
- Tags: Mozilla Firefox, jardinier, software, password
- Q&A 2006-08-20
- Select Address Bar (xpi)
- Select Address Bar fixes a really annoying bug. The extension selects the address bar when you click on it, like the behavior of the address bar on windows. Select Address Bar makes it easier for people who are switching to linux to use Firefox. This version is the first release...
- Tags: Address Bar, Travis Athougies, Linux, Web Browsers, Construction, UNIX, Operating Systems, Open Source, Software, Internet
- Software downloads 2007-10-01
- << Previous
- page 1 of 1
- Next >>
