Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: hneal98
  • Content: Threads
  • Order by date
  1. hneal98

    SQL and CASE statement issue...

    Hi Everyone, I need to know if this is possible? SELECT CASE WHEN IDI.ID = E.ENROLLID THEN 'Entry' WHEN IDE.ID = E.EXITID THEN 'Exit' END AS Test FROM Enrolled E INNER JOIN TestTable IDI ON E.EnrollID = IDI.ID INNER JOIN TestTable IDE ON E.ExitID = IDE.ID If not, is there a way to do...
  2. hneal98

    Another Grouping and Self Join problem

    Hi, Hi have a table that is grouped and setup similar to this... Dates..............................Lots.............Sets 01/01/2013 06:25:20..........1................A1 01/02/2013 04:25:20..........1................A1 01/03/2013 05:10:18..........1................A1 01/03/2013...
  3. hneal98

    Help With Multi-Row comparison logic

    I am trying to do a comparison of material loaded to different machines at different times/dates. I need to find 8 minute gaps and 1 hour gaps in dates. Here is an example of data: <code> Row_id Date LotID Amount Machine 59ACD 2013-07-10 08:50:21.000 209...
  4. hneal98

    Carry over partial total from week 1 to week 2...

    Hi Everyone, I also posted this under Oracle, but I know more about SQL Server, os it should be easy to translate any differences... I have something like the following... Date ........ Hours ........ 980X 03/08/13 ........ 4 ........ 98 03/08/13 ........ 2 ........ AM 03/08/13 ........ 2...
  5. hneal98

    For the 9/80 Work Week, Need to Add Hours from PM of First Friday To Next Friday...

    Hi Everyone, I have something like the following... Date ........ Hours ........ 980X 03/08/13 ........ 4 ........ 98 03/08/13 ........ 2 ........ AM 03/08/13 ........ 2 ........ NULL 03/08/13 ........ 3 ...
  6. hneal98

    Confusion with Subreports and Parameters...r

    Hi, I have two datasets, one from SQL Server and the other from Oracle. The Oracle dataset is for the main report and the other is for a subreport. I am new to Reporting Services, so I don't have a clue how to get through this... In the subreport, I have created two perameters. One for...
  7. hneal98

    Calling an Oracle Stored Procedure from Report Services...

    Has anyone had any experience with using an Oracle stored procedure as a dataset for reporting services? If so, can you tell me how you set it up to return the data to reporting services? I want to do this, but i know you cannot do like in SQL Server where you can end the stored proc with a...
  8. hneal98

    Help with PHP Variables and HTML Sytax...

    Hi, I am lost. I need to know if something like the following is possible: <?php if($flamt>0) { "<img src='http://www.mydomain.com/affiliate/scripts/sale.php?TotalCost="{$flamt}"&ProductID=001' width=1 height=1>"; } if($blamt>0){ echo "<img...
  9. hneal98

    Can someone help with PHP Error I don't understand...

    Hi, I am trying find out why an piece of code will not execute in PHP. I am just learning, so I don't understand why this is happening. I installed Firebug for Firefox on my PC so I can debug the PHP code. I have an include that calls another file, but it does not seem to actually get...
  10. hneal98

    I need help understanding PHP Include...

    Hi, I am just learning PHP and I have an issue with a site where an include for a file that once showed up at the end of a transaction no longer shows up. What does not make sense to me is there is a piece of code that checks to see if an email went out and if so, it is supposed to "include"...
  11. hneal98

    Help! SQL Server 2008 Shows 2000!!!

    Sorry, but I am a bit stupid with the new SQL Server versions. I set up a SQL 2008 on my PC, but had problems loading a sample database. I ran SELECT @@Versions and it returned Version SQL Server 2000. Can someone explain why this would be and how do I upgrade it to 2008? Thanks and sorry...
  12. hneal98

    Need help with Not-in queries.

    Hi, I know how to do a not in if I am just dealing with one field, but what if I have the following situation; how should I handle that? I have two tables that would link on id, transaction_code and Transaction_date. For any record, any of these fields could be different. for example...
  13. hneal98

    What is the fastest way to denormalize data?

    I have a table like this: field1 field2 a aa a ab a ac b ba b bb c ca c cc c cd I would like it to look like this: field1 field2 a aa,ab,ac b ba,bb c ca,cc,cd What is the best way to do this in...
  14. hneal98

    Get Last Termination Instance And Calc # of Days...

    Hi I have an issue where i have sets of enroll segments like this: MemID EnrollID EffDate TermDate A1 enr1 01/01/2006 03/31/2006 A1 enr2 05/01/2006 06/30/2006 A1 enr3 07/01/2006 12/31/2078 A2 enr1 02/01/2006...
  15. hneal98

    Query Runs Fast, but View is very SLOW - HELP!!!

    Hi I have a view where if I run the query with in it, it runs in 3 seconds, but if I try to run the view, it seems to never end. Any ideas as t why this might happen? Thanks, Harvard
  16. hneal98

    Flag one of mulitple records as 'N'. Possible???

    Hi all, I have a situation where I have records that could show multiple times in a query due to multiple claim ids. However, I have set up a field as a Y/N flag where I only want to flag one as Y, the others I want to be N. It does not matter which is selected as Y, but just one. Example...
  17. hneal98

    How can I find move to the last cell that has data with Macro?

    I need to create a macro that will always move to the last cell in a spreadsheet that has data. To give you an example, one time that last cell might be at row 15 and another at row 200 and another time at row 130, etc. When I record a macro, it basically hardcodes the cell references, so the...
  18. hneal98

    Excel, How do I change Servers???

    I have an excel spreadsheet that imports data from SQL Server via the Import External Data query. I want to change the server, but can't find anything on how to do this. Anyone have any ideas? Thanks, harvard
  19. hneal98

    Find Group Where All Members Are Denied...

    Can someone tell me how to do the following? I have a group of records where there is a header table and a detail table. The header and detail share a common ID, of course. The detail table has a status field where it can be ok or deny. I want to find all records in the header where all...
  20. hneal98

    Excel - Compare two lists for what's missing in one?

    Does anyone know if there is a way to compare two lists and find all items in one that is not in another? I prefer not to use VBA, but if I must, i will. Thanks in advance.

Part and Inventory Search

Back
Top