Search Result

Collapse
6 results in 0.0039 seconds.
Keywords
Members
Tags
exclude
  •  
  • NDayave
    started a topic Looking for some help with JOIN logic
    in SQL Server

    Looking for some help with JOIN logic

    Good Day,

    I have a number of tables that need to be joined to gether and up to now everything has been fine. I now need to exclude old files that are identified by a sequence number; newer records have a higher number.

    The joins currently look like this:

    Code:
    FROM a
	INNER JOIN b
		ON(a.resource_id = b.resource_id)
	INNER JOIN c
		ON(a.resource_id = c.apar_id)
	INNER
    ...
    See more | Go to post
    • Allend
      started a topic Using regex to add multiple restrict conditions to preg_replace array
      in PHP

      Using regex to add multiple restrict conditions to preg_replace array

      I have a great little script that will search a file and replace a list of words with their matching replacement word. I have also found a way to prevent preg_replace from replacing those words if they appear in anchor tags, img tags, or really any one tag I specify. I would like to create an OR statement to be able to specify multiple tags. To be clear, I would like to prevent preg_replace from replacing words that not only appear in an anchor...
      See more | Go to post
      • neelsfer
        started a topic How to calculate a monthly average (excluding certain months) in query
        in Access

        How to calculate a monthly average (excluding certain months) in query

        Its easy to calculate averages in Access queries using the Totals method, but what do you do in the following instance?

        month-------quantity
        1 ------------10
        2-------------0
        3-------------20
        4-------------0
        5-------------20

        The normal way would be to add up and divide by the months
        ie 50/5 = 10

        My problem is that i want to EXCLUDE the months where you have a...
        See more | Go to post
        • nicebasic
          started a topic How To Sort Records Alphabetically BUT Exclude Just One Record
          in ASP Classic

          How To Sort Records Alphabetically BUT Exclude Just One Record

          I have already asked this question in the Access Department. A really intelligent programmer helped me solve the problem in Access IDE. But I'm working on an ASP project, and I need the solution in ASP, which is somehow different from Access VBA in the Syntax.

          I would like to have a query for ASP Classic to be applied on an Access database.

          1. Imagine that we have a table with the name of "Country".
          2. Imagine...
          See more | Go to post
          • nicebasic
            started a topic How To Sort Records Alphabetically BUT Exclude Just One Record
            in Access

            How To Sort Records Alphabetically BUT Exclude Just One Record

            I would like to have a query for ASP Classic to be applied on an Access database.

            1. Imagine that we have a table with the name of "Country".
            2. Imagine that we have a column in "Country" that has this name: "CityMajor"
            3. Imagine that we wish to have a query sort the items in this column, but with one exception: One of the records should stand on top of the other records while other records...
            See more | Go to post
            • vavc1980
              started a topic Replace all special characters except asterisk
              in ASP .NET

              Replace all special characters except asterisk

              Hello,

              I've been trying to find a way using regex to replace all special characters and spaces in a string but leaving the asterisk there.
              Example:
              (8.88)***1 234--

              result should be:
              888***1234

              I've been looking on the web (still am) and also trying myself but I just can't find it, what I have removes the asterisk too, which I don't want. Here's what i have (by the way this is...
              See more | Go to post
              Previous template Next
              Working...