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!

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

Recent content by gmmastros

  1. gmmastros

    Pulling Minimum Lengths

    try this Where [CITY ST ZIP] like '%[0-9][0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]%'
  2. gmmastros

    Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less

    Sounds to me like your original (slow) query is somehow getting executed, even if you don't think it is. Just for fun, and just for temporary, try adding to the where clause "Where 1 = 0". If the original query is still somehow running (without you wanting it to) this where clause should return...
  3. gmmastros

    Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.

    The answere is right there in the error message: query expression 'Birthday = and Birthmonth ='. For some reason, the Format function must be returning an empty string. Maybe dSelectDate is an empty string. You should probably verify that before you run the query.
  4. gmmastros

    Commas in CSV fle

    This was not a simple mistake. It required knowledge of both commands, Print and Write. It also required knowing the nuanced difference between them. Regardless, I'm glad you got your problem sorted.
  5. gmmastros

    Commas in CSV fle

    From here: https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/writestatement The link here takes you to VBA documentation, which can sometimes be different from VB6, but in this case, they are the same.
  6. gmmastros

    Commas in CSV fle

    Try changing Write #intF, sNewLine to Print #intF, sNewLine
  7. gmmastros

    Commas in CSV fle

    This is probably an easy fix, but I think more information would be helpful. Are you starting with a CSV file, or are you creating it? If you are creating it, what is the source? What does your code look like now?
  8. gmmastros

    Need help creating a date from two fields to be used in where clause

    You'll need to be very careful here. Storing a month as the name ("January", "February") can be problematic because of typos and whatnot. Regardless, since you want to compare these things as dates (as you should), you will need to also have a "day" component, specifically, which day of the...
  9. gmmastros

    Group results into one row

    Try this... SELECT ProductCode, CASE WHEN PackStatus = 10 THEN 'Free' WHEN PackStatus = 11 THEN 'Allocated' ELSE 'Received/Reconciled' END AS Status, Min(CASE WHEN Length = 2.4 THEN Packs ELSE NULL END) AS [2.4], Min(CASE WHEN Length =...
  10. gmmastros

    Buttons not aligned after another button is clicked

    Feherke, First, I agree with your assesment of the problem. It seems to me that there are several ways to solve this problem by setting display to: 1. inline 2. unset 3. (empty string) Setting the display to inline would only work if the element was set to inline previously. If there was...
  11. gmmastros

    select a single row based on conditions in multiple rows

    What you have here is considered an Entity-Attribute-Value table. https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model This type of table structure is fairly decent when storing "sparse" data, but doesn't do so well otherwise. The problem with this type of data structure...
  12. gmmastros

    Status of dBase?

    I haven't touched a dbase file in.... a couple months. It is common for map data to be distributed in "Shape Files". Each map layer has it's own set of shape files. For example, street centerlines.... the shape files are a set of files. One for the config, One for the index, one for the...
  13. gmmastros

    SSMS question

    The keyboard shortcut is CTRL-SHIFT-R. This refreshes the intellisense cache and prevents the red squigglies.
  14. gmmastros

    split one row into multiple rows... help pls

    Your expected results are a little weird with respect to the dates. There are various methods of creating multiple rows from a single row. You could join to a table that has multiple matches, this is a bit more complicated but can sometimes work well depending on your situation. In this...
  15. gmmastros

    SQL Performance

    Greg, I think you're looking at the details instead of the bigger picture. I can probably count on one hand the number of times I've needed to rename a column within a table. I encourage you to step back and think about why you want to rename a column. I suspect this is to facilitate reporting...
See more

Part and Inventory Search

Back
Top