Search results

  1. C

    Hopefully this is close enough: shrinking database transaction log?

    If it's SQL Server 2000, switching from Simple to Full for the Recovery Model leads to the transaction log no longer being truncated on a Complete Backup, which leads to runaway transaction log file size. Been there; done that, but with running out of disk space being the event that made the...
  2. C

    MSI GTX 650 1GB OC $69.19 AR ($15)

    http://www.amazon.com/MSI-Computer-OC-PCI-Express-N650-1GD5/dp/B009733DFA/ Rebate is good through the end of the year. Price may change without warning. (It was about a buck more at one point yesterday.)
  3. C

    dead psu or dead mobo?

    CMOS jumper on the wrong pins? IIRC, I've had that happen to me.
  4. C

    Website Error Sparks Jump In Oil Prices

    And a refinery does what in relation to crude oil? ;)
  5. C

    Video Gamer Shot Foiling Robbery

    "Witnesses told how Adam tried to block the thugs’ escape." Bad idea, if that's what really happened.
  6. C

    Website Error Sparks Jump In Oil Prices

    In other news, the price of flour has jumped on reports of fire at Imaginary Bakery...
  7. C

    20 Years Of Gates’ Predictions

    By 1995, even my behind-the-times parents had owned a VCR for many years. What'll his next prediction be, the invention of the wheel? :rolleyes:
  8. C

    IBM Adds Cell To Mainframes

    How long before Sony stuffs a Blu-Ray drive in, too?
  9. C

    Ken Kutaragi Retires

    But... but... but... who will tell us when the next generation begins? :rolleyes:
  10. C

    So.... GTA IV trailer what are your thoughts so far?

    Ironically, "setting Halo in Disneyland" sounds like a concept with potential...
  11. C

    Warm: X800 Crossfire PCIE $79 from ATI

    Ordered one. Thanks cefoskey and BossBorot.
  12. C

    Quick help with SQL select

    Perhaps you have a duplicate row in vwMMAllKeyholders. Try SELECT * FROM vwMMAllKeyholders WHERE NameLast = 'kinley' ORDER BY NameLast, NameFirst; to see if you do.
  13. C

    MSSQL Query...having some trouble

    If I understand you correctly, you can get what you want by combining (pun avoided) parts of your 2 queries together like so: select C.contact_code, C.company_code from contacts C INNER JOIN ( select contact_code from contacts group by contact_code having (Count(contact_code) > 1) )...
  14. C

    MySQL query problem

    You're welcome :cool:
  15. C

    MySQL query problem

    Assuming the syntax on your version of the query is correct, this should get you what you're asking for: SELECT t.first_user_id, t.last_user_id, u1.user_name, u2.user_name FROM table AS t JOIN users AS u1 ON t.first_user_id = u.user_id JOIN users AS u2 ON t.last_user_id = u2.user_id
  16. C

    Syntax Error In Update Command

    What about the datatypes of the columns in TableObject?
  17. C

    Syntax Error In Update Command

    Maybe it's the datatype of a column in TableObject that's causing the problem, or perhaps you're trying to update a column with a value that's too large?
  18. C

    Syntax Error In Update Command

    For OleDb, yes, it's all about parameter order and the names are ignored.
  19. C

    Syntax Error In Update Command

    Is [EmployeeID] an identity/autonum column? If so, you (generally) can't update it, nor (generally) would you want to do so.
  20. C

    Syntax Error In Update Command

    You're welcome. I know what you mean. Which line is throwing the current exception?
  21. C

    Syntax Error In Update Command

    UPDATE Employees SET ([EmployeeID] = ?, [FirstName] = ?, [LastName] = ?, [Position] = ?, [ShiftNumber] = ?, [UserName] = ?, [fldPassword] = ?, [PermissionsLevel] = ?, [ComputerName] = ?, [ClientType] = ?, [LoggedIn] = ?, [DateHired] = ?, [TicketExpires] = ?, [DateTerminated] = ? WHERE...
  22. C

    datetime datatype in SQL Server 2005

    You're welcome. :cool: If you use datetime or smalldatetime as the storage type, there'll always be a time component to it. I would guess that the times being stored correspond to the local time on the client machine where the update/insert causing event occurred. You could set the...
  23. C

    datetime datatype in SQL Server 2005

    You don't have to, just make sure the string in the parameter is in the mm/dd/yyyy format when the month and/or day parts are used. '11/09/2005' rather than '11/9/2005', for example. SELECT [Lab ID], Location, [Department Code], Model, [No. of Computers], [Date of Purchase], Notes FROM...
  24. C

    Data Storage Question

    If the data is read only, a data structure appropriate to how the data is being looked up would perform better than any of the three options listed.
  25. C

    datetime datatype in SQL Server 2005

    If you want to get rid of time, use CONVERT and pick the style you want: http://msdn2.microsoft.com/en-us/library/ms187928.aspx You probably want 101 as the style. Note that it gives mm/dd/yyyy, which means you'd need to match to 11/09/2005. It'll be more efficient to ensure the parameter uses...
  26. C

    datetime datatype in SQL Server 2005

    CAST or CONVERT the DateColumn to a character type.
  27. C

    Parameterized query vb.net 2005

    No, one doesn't need to supply any single quotes. Nor would there be any danger of SQL injection, unless one tried to implement a bad hack to "fix" a non-existent problem.
  28. C

    MySQL query questions

    Hmm... Looks like I answered something other than the actual question asked. Probably because the actual question falls into the category of... "odd"... This probably works, yielding the distinct group count as the first row. (Having it appear as the last would be rather pointless, as...
  29. C

    MySQL query questions

    I don't use MySQL, but the answer is likely the below or something very similar. SELECT thegroup, COUNT(*) AS thecount FROM thetable GROUP BY thegroup
  30. C

    Help with an SQL statement

    Glad to be of help :cool:
  31. C

    Help with an SQL statement

    You need one more single quote after the C UPDATE ReportConfig SET DefaultParam = 'not ({custinv.Type_Of_Invoice} in [''CANCEL'' , ''Dropped'', ''Transfer'', ''LayAway'', ''Payment'']) and {custinv.Status} = ''C''' WHERE (FileName = 'pBITS/3028-TaxReport.rpt')
  32. C

    Help with an SQL statement

    You're welcome :cool:
  33. C

    Help with an SQL statement

    For each single quote you want inside the string, you probably need two single quotes back to back: NSERT INTO ReportConfig (Title, Filename, Category, DefaultParam, UseDateRange, UseDefaultParam, DateField, NumberOfFiles) VALUES ('Tax Report', 'TaxReport.rpt', 'Financial'',''not...
  34. C

    Functions...Is there a better way to do this?

    Take a closer look at the posted code... especially the fttometers function. I didn't at first, but after closer inspection, the nature of the issue seems to be quite different from my initial expectations...
  35. C

    Functions...Is there a better way to do this?

    Also note that: --You're reading a real number into an integer variable. --The issue above suggests that the types for all your functions, other than main, are incorrect. --feettoin and intocm have an error in common. --intocm introduces inaccuracy by converting a real number into an...
  36. C

    Functions...Is there a better way to do this?

    EDIT: note: comments below represent earlier beliefs that don't hold up after a more careful look at the code posted above. Read the comments for the first three functions, in order... (Though I'd vigorously dispute that the solution (likely) being sought (presumptively by an instructor)...
Back
Top