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: kaht
  • Content: Threads
  • Order by date
  1. kaht

    Are these 2 queries functionally equivalent?

    As the title implies: select sum(t.TOTAL) recordTotal from TRANSFERS..REPTRANSF t inner join TRANSFERS..REPHIERARCHY h on h.VP_ID = 'ES3891' and h.AGENT_UUID = t.AGENT_UUID where t.COL_DAT = '2008-03-01' select sum(TOTAL) recordTotal from TRANSFERS..REPTRANSF where COL_DAT =...
  2. kaht

    Update a row incrementally based on data from other table

    I have 2 tables which are linked by userid. There is a column in the first table that I need to update based on the way the table would be sorted using criteria from another table. For example: set nocount on declare @a table (userid char(3), start smalldatetime, tiebreaker tinyint) insert...
  3. kaht

    Rewrite update to get rid of subquery

    I have 2 tables, a calendar table and a vacation table. In the calendar table there is a date column and a slotsFull column. The slotsFull column represents how many people have taken a vacation for that particular time. In the vacation table there is a vacStart and a vacStop column that...
  4. kaht

    update range of rows specifed by date range in other table

    I have a table (VPOFF) that has a row for each 15 minute increment an office is open. In another table (VPVAC) are rows that define the start and stop time for employee vacations. In one procedure I'm inserting some bulk vacation rows, and I need to increment the SFULL column by 1 in the VPOFF...
  5. kaht

    SQL Teaser: Datetime (pt 2)

    select convert(datetime, '2007-01-01 00:00:00.001') select convert(datetime, '1970-01-01 00:00:00.002') select convert(datetime, '1970-01-01 00:00:00.003') select convert(datetime, '1970-01-01 00:00:00.004') select convert(datetime, '1970-01-01 00:00:00.005') select convert(datetime, '1970-01-01...
  6. kaht

    Rubik's

    I know a Rubik's cube is a puzzle in and of itself, but my question involves only a small part of a Rubik's cube. Imagine you are holding a Rubik's cube and you are looking at the white face of the cube. If the cube is oriented such that the green face is on the right side, that will put the...
  7. kaht

    Strange floating problem with IE

    I'm having a weird issue with IE and clearing floats. First, a VERY cut down version of my code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>test</title> <meta...
  8. kaht

    IE7 - bottom margin craziness

    So, my machine got the IE7 critical update today. What stinks is my company is mostly win2k machines, so this problem isn't even very relevant for the time being (till they upgrade to XP). Anyway, I have to start with a disclaimer - these pages have a lot of very unnecessary markup. It's used...
  9. kaht

    Ignoring columns when grouping data

    I'm wanting to know if something like this is possible. I'll try to explain this in simplest terms. Assume I have a database like so: myTable num type junk --- ---- ---- 1 a abc 1 a xyz 1 b abc 1 c xyz Now, the query that I'd like to write would pull a list...
  10. kaht

    Sexy fading effect

    On my company's main webpage, I decided to put some info about each of the applications when you hover over the links to them. Using the basic function from this page, I came up with this - which works out pretty nice: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"...
  11. kaht

    ltrim &amp; rtrim returning null

    when I run the following command: ltrim(rtrim('')) I am getting a value of NULL returned. up until earlier today this command has always returned '' is there a setting that can be changed that will cause this command to return different values? the odd thing is that if I change to a...
  12. kaht

    ASP, Stored Procedures, and you

    (This example uses Jscript instead of VBscript) Here's my situation. When I call a stored procedure that returns a result this is how I usually pull the info: var strConn = "Provider=SQLOLEDB;Data Source=servername;Initial Catalog=catalogname;User Id=userid;Password=password"; var oConn =...
  13. kaht

    Where's the missing dollar?

    I was hesitant to ask this question earlier because it didn't really have a whole lot to do with programming. But after the question about the lottery turned into more of a math discussion I figured this would be fair game. Before I ask the question let me add that it doesn't really have an...
  14. kaht

    gap shown in IE

    I've cut the page down considerably so that it will be easier to show my problem. I have a sort list that sits right on top of the scrollable list of exception codes. I need to make a printer friendly version of this page so I wanted to put a link out to the left side of the sort buttons...
  15. kaht

    Please scan my Hijackthis log

    I ran this hiijackthis scan on one of the machines here at the office and here is the log. There were a few adware alerts that popped up in a norton scan that it could not get rid of. Does anybody see anything malicious in this list? Thanks in advance. Logfile of HijackThis v1.99.1 Scan...
  16. kaht

    Minor Excel Annoyance

    I'm using MS Excel 2003. Every time I open a document in excel the "Work Items" toolbar shows up. I right click on the toolbars section and uncheck it every time, however it's there again each time I reload excel. Is there a way to disable this toolbar so that it stays gone? -kaht ...looks...
  17. kaht

    div repositioning problem

    disclaimer: I didn't write all the table stuff on the page before you all tear me a new one [smile] The div "content" is repositioned down below "menu" when the browser is resized smaller horizontally (in IE only). This wouldn't be that big of a problem, but we have to assume that the users...
  18. kaht

    2 layout questions

    I have 2 problems with my layout (please ignore the colors, they're bad but I used them for identification.) 1. In IE there's a small horizontal gap between logo and header. 2. I want the footer to appear at the bottom of the page, but if there is more material in the menu, the footer will...
  19. kaht

    childNodes collection: IE and Firefox differences

    I recently started making one of my web applications for work more cross-browser friendly. This whole time it had been developed for IE because we run a microsoft shop (unfortunately). I ran into a bug when referencing table elements using the parentNode and childNodes collections. Take the...
  20. kaht

    Regexp to validate a Date (warning, stretched post)

    Enjoy: <html> <script language=javascript> function validateForm() {var txt = document.forms['blahForm'].elements['blahText']; if (/(((0[1-9]|[12][0-9]|3[01])([/])(0[13578]|10|12)([/])(\d{4}))|(([0] [1-9]|[12][0-9]|30)([/])(0[469]|11)([/])(\d{4}))|((0[1-9]|1[0-9]|2[0-8])...

Part and Inventory Search

Back
Top