]]>The post Spreadsheet Server on AS/400 appeared first on IT Answers.
]]>http://itknowledgeexchange.techtarget.com/itanswers/spreadsheet-server-on-as400/feed/0On the AS/400 iSeries can one use SQL queries to update filehttp://itknowledgeexchange.techtarget.com/itanswers/on-the-as400-i-series-can-one-use-sql-querys-to-update-file/
http://itknowledgeexchange.techtarget.com/itanswers/on-the-as400-i-series-can-one-use-sql-querys-to-update-file/#respondTue, 19 Jan 2010 21:55:48 +0000New Answer by Michael Tidmarsh

]]>The post On the AS/400 iSeries can one use SQL queries to update file appeared first on IT Answers.
]]>http://itknowledgeexchange.techtarget.com/itanswers/on-the-as400-i-series-can-one-use-sql-querys-to-update-file/feed/0Oracle 9i installationhttp://itknowledgeexchange.techtarget.com/itanswers/oracle-9i-instalation/
http://itknowledgeexchange.techtarget.com/itanswers/oracle-9i-instalation/#respondWed, 01 Oct 2008 20:38:40 +0000New Answer by Michael Tidmarsh

]]>The post Can somebody provide me SQL questions based on various situation? appeared first on IT Answers.
]]>http://itknowledgeexchange.techtarget.com/itanswers/can-somebody-provide-me-sql-questions-based-on-various-situation/feed/4I want to parse data from one field into two based upon criteria.http://itknowledgeexchange.techtarget.com/itanswers/i-want-to-parse-data-from-one-field-into-two-based-upon-criteria/
http://itknowledgeexchange.techtarget.com/itanswers/i-want-to-parse-data-from-one-field-into-two-based-upon-criteria/#respondThu, 04 Dec 2008 16:21:35 +0000I have lots of data with disparate information in one field and I need to take all information to the right of any * that might appear into a separate field? There will be an * about 10% of the time. Examples of the field in question. Example 1: CKD Stage I ****250.40/585.1 Example 2:...

]]>I have lots of data with disparate information in one field and I need to take all information to the right of any * that might appear into a separate field? There will be an * about 10% of the time.

Examples of the field in question.

Example 1:
CKD Stage I ****250.40/585.1

Example 2:
/Prosthesis Ca *185

So in the above two examples, I would want a separate field for 250.40/585.1 in the first example, and a separate field for 185 in the second example. The original field in the first would then be CKD State I and in the second example, the original field would be replaced with /Prosthesis Ca

]]>The post Open ended SQL queries appeared first on IT Answers.
]]>http://itknowledgeexchange.techtarget.com/itanswers/open-ended-sql-queries/feed/1Access 2003 SQL sub-query within queryhttp://itknowledgeexchange.techtarget.com/itanswers/access-2003-sql-sub-query-within-query/
http://itknowledgeexchange.techtarget.com/itanswers/access-2003-sql-sub-query-within-query/#commentsWed, 02 May 2012 01:16:15 +0000I’m trying to extract all Person.ID eligible to sit a Level 1 study exam from our database. So I setup a query to look for members with study exam level 1 not equal to “pass” or Is Null, thinking it would give me all people who hadn’t sat or hadn’t passed level one exam. However...

]]>I’m trying to extract all Person.ID eligible to sit a Level 1 study exam from our database.
So I setup a query to look for members with study exam level 1 not equal to “pass” or Is Null, thinking it would give me all people who hadn’t sat or hadn’t passed level one exam. However where it doesn’t work is where a person has sat and failed and then later sat and passed. Because the query looks at it on a record by record basis any person who failed is picked up regardless if they then passed at a later time. I think what I need is to somehow look at all study exam records for a person and if there they have no level 1 pass in any of their study records then include them in the list.

]]>The post SQL Server 2005 Query Very Slow in the first run appeared first on IT Answers.
]]>http://itknowledgeexchange.techtarget.com/itanswers/sql-server-2005-query-very-slow-in-the-first-run/feed/6SQL Server 2012 Question: How to find last executed queries by database?http://itknowledgeexchange.techtarget.com/itanswers/sql-server-2012-question-how-to-find-last-executed-queries-by-database/
http://itknowledgeexchange.techtarget.com/itanswers/sql-server-2012-question-how-to-find-last-executed-queries-by-database/#respondThu, 10 Oct 2013 16:07:47 +0000http://itknowledgeexchange.techtarget.com/itanswers/sql-server-2012-question-how-to-find-last-executed-queries-by-database/New Answer by Michael Tidmarsh