Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- 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
- 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
- Oracle PL/SQL
- When i use the Oracle built-in function GET_APPLICATION_PROPERTY within the sub-query of an sql statement i get an error which states "You may not use GET_APPLICATION_PROPERTY function in SQL"...what can be the workaround for this problem?Sounds like you're using forms. Since you did not post the sql statement, I...
- Tags: Programming languages, SQL
- Q&A 2005-07-17
- General SQL Parser .NET version (zip)
- General SQL Parser is developed to help people who want to check syntax of SQL statements, pretty print out SQL statements, and parse SQL statements into parse tree in their program. It can also provides more detail information about a SQL statement such as statement types (Select, insert, update, delete...
- Tags: Microsoft .NET, Statement, SQL, General SQL Parser, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2006-12-07
- SQL syntax for querying AD group membership
- I've established a connection to Active Directory through Crystal Reports. Now I need to write an SQL select statement to return all computer accounts and their group memberships. My statement returns all the computer accounts in the target OU, but the MemberOf field is empty. I've included below my...
- Tags: PRODUCTIVITY, Programming languages, advertisement, cantrejj@..., computer account, SQL, computer
- Discussion threads 2007-07-22
- 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
- Dealing with embedded sort orders in SQL
- So what's the SQL?What's the SQL that properly invokes your UDF?Why a UDF?select * from TestSort order by CONVERT(int,SUBSTRING(CodeToSort,2,PATINDEX('%[^0-9]%',SUBSTRING(CodeToSort,2,200)+'|')-1))Your select does not give same resultYour select did not give the ssame result, so the UDF might still be the course to goWhat's the result to be same as?The article does...
- Tags: aikimark@..., database, SELECT, software, SQL, SUBSTRING
- Discussion threads 2005-09-27
- Evaluating Accounting Software: Print a Financial Statement to the Screen
- The process of printing a financial statement to screen can be very revealing. To start with, this allows you to see how many default financial statement formats come standard with the system. Some products provide a balance sheet and income statement while others provide numerous standard reports including a Statement...
- Tags: Accounting, Financial, Financial Statement, Financial Statements, Financial Accounting, Financial Planning, Finance
- White papers
- Analyze performance through common-sized income statements with Excel
- Perform percentage and comparison analyses in Excel by creating a common-sized income statement. Find out how in this tip by Mary Ann Richardson. How do your company's profit margins compare with others in your industry? What percentage of revenue goes to salaries? What percentage of revenue goes...
- Tags: Microsoft Excel, Mary Ann Richardson, Operational accounting, performance, income statement, income, Click Copy, Microsoft Office Suite Excel Tips Newsletter, Finance, Microsoft Office, Office Suites, Software
- Technical articles 2007-04-10
- 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
- Query for data with the SELECT statement in MySQL
- This sample chapter, taken from MySQL 5.0 Certification Study Guide, discusses how to use the SELECT statement in MySQL to retrieve information from database tables. Learn how to use the SELECT statement to retrieve information from database tables. This information will help you prepare for the MySQL...
- Tags: Sams Publishing, MySQL, MySQL 5.0, Open Source, Databases, Enterprise Software, Software, Data Management
- Book chapters 2006-02-07
- SMS2003 question about query and wql
- Hi all -- I am trying to run an SMS2003 query against two Object Types. The manual says I cannot do this and must create my own WQL statements with the 'unspecified' object type. I can get the WQL statements to work by themselves, but when I put them together...
- Tags: WQL Statement, WQL
- Q&A 2006-04-24
- Store Result of SELECT stament to be used to UPDATE another table
- Hi, im trying to update a field of a table which is done through the results of a select statement. I need to be able to a store the results of the select statement which can then be used to determine if an update another table is initiated. This is...
- Tags: Notebooks, twanstall@..., laptop computer
- Discussion threads 2007-03-24
- 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
- WHERE Vs. IF Statements: Knowing the Difference in How and When to Apply
- When programming in SAS, there is almost always more than one way to accomplish a task. Beginning programmers may think that there is no difference between using the WHERE statement and the IF statement to subset the data set. Knowledgeable programmers know that depending on the situation, sometimes one statement...
- Tags: Statement, SAS Institute, Development Tools, Software Development, Software/Web Development
- White papers 2006-02-28
- show all
- SQL statement I am creating a where statement showing not like fields. But I want to show all in the range. ie. combo = fcitem = fc, reNot like statement will show item re, but I want to view the fc alsoNot like what?for example if you have the values...
- Tags: Programming languages, cjconnell@...
- Q&A 2006-08-14
- Vision Statement Mentor (msi)
- Vision Statement Mentor guides you through the steps of creating core values statements and vision statements for your church and ministries. A church vision statement or ministry vision statement is a tool to help you communicate the vision which God has entrusted to you. A vision statement can invoke passion...
- Tags: Vision, Vision Statement, Rohawk, Strategy, Management
- Software downloads 2008-02-29
- If statment
- I need a formula to calculate a difference of Time A which contains total of scheduled week hours minus Time B which contains total of actual week hours. For example if Scheduled hours were 40 hours and the actual hours worked for that shift was 44 hours. ...
- Tags: A-B
- Q&A 2005-08-01
- 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
- << Previous
- page 1 of 1
- Next >>
