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 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: *

  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...
  16. gmmastros

    PK-FK Relations

    May I ask... what is the point of analyzing this database? Is the ultimate goal to improve performance? -George Microsoft SQL Server MVP My Blogs SQLCop twitter "The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
  17. gmmastros

    Where do we put public functions in C# (modules don't exist) ?

    You can use a static class and static methods to do this. Ex: public static class Anything { public static void Search() { MessageBox.Show("Did you find it?"); } } Then, anywhere else in your code, you can do this.... Anything.Search(); In this example, the...
  18. gmmastros

    Insert into query adds records to unreadable format, how do I change that?

    Be very careful about changing the collation of anything. This is a very complex issue and should not be taken lightly. Collations do not affect how the data is stored. It only affects how data is sorted and compared. There is a default collation on the SQL Server instance. This is used...
  19. gmmastros

    Field types question

    I've changed my mind numerous times throughout my career. Initially, I was in the camp, "shortest fields possible", but in recent years it's morphed into "Shortest possible with wiggle room". To be clear, I rarely use marchar(max) unless it's a Notes column, because then you never know. Max...
  20. gmmastros

    VB6 Post to webservice with MSXML2 error

    strongm, Thanks for the advice. Unfortunately, I get the same error. Error: The connection with the server was terminated abnormally Code: 80072EFE Source: WinHttp.WinHttpRequest I think you know what my product name is, so I was wondering if you had an opportunity to run the code and whether...

Part and Inventory Search

Back
Top