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!

Search results for query: *

  • Users: bobpv
  • Order by date
  1. bobpv

    How do you link a credit memo to the sale invoice?

    Never mind, discovered that the user had never linked the CM to an invoice! No wonder I could not get a link.
  2. bobpv

    How do you link a credit memo to the sale invoice?

    I thought from reading the data definitions it would be in the Link to Another trx field, but does not seem to be there. Can anyone point me in the right direction? I just want to subtract the credit form the total sale and display that amount in a Crystal Report, should be simple but is giving...
  3. bobpv

    How to get the past 6 full months spanning a year

    I wound up creating a couple of functions to give me the dates I wanted, one for start date which I can then use to back out 6 months using the MONTH - 6, the other to give me end dates of the month which I can apply ot the query. Many thanks to all for the suggestions and the explanations...
  4. bobpv

    Date values, start and ending for a month

    RTag, 2 different issues, one to pull 6 full months from the table, the other to extract the start and end dates of those 6 months. I wound up creating a couple of functions to give me the dates I wanted, one for start date which I can then use to back out 6 months using the MONTH - 6, the...
  5. bobpv

    Date values, start and ending for a month

    Getdate() -180 won't work, due to the months values (Sept to Feb would be 181, or 182 if leap year). I am not sur eif there is a way to make that adjustment? driex, yes, I will need the month values in distinct years, to expand what I need to do: SELECT SUM(CASE WHEN movedate <= '2010-09-01'...
  6. bobpv

    Date values, start and ending for a month

    I need to get the 1st and last day of the last full 6 months ie, Feb,1,2012 and Feb 28,2012 (or 29 if leap year) Jan 1, 2012 - Jan 31,2012 - Dec 1, 2011 - Dec 31,2011 - Nov 1,2011 - Nov 30,2011 and so on. I need that series in separate fields in order to use them in a query to gather the prior...
  7. bobpv

    How to get the past 6 full months spanning a year

    Hello gurus! I am confused by the DATEDIFF and DATEADD options when it comes to spanning a year, or when months do not all have 31 days.. I wish to grab all dates in a 6 month range of full months, which span a year. For example, if the query is run from March 15th, 2012, the desired result...
  8. bobpv

    Cannot log into SQL 2000 from Client using Named Instance

    Thank you very much for the reply, let me ask this, The Client Network setup did use the dynamic port option, does this also need to be done at the server- i assume the network setup utility is used? Second, anything on enable and start SQL Browser? I am not familiar with this.
  9. bobpv

    Cannot log into SQL 2000 from Client using Named Instance

    This is causing me grief, and I have not been able to get a resolution from any of the consultants I engaged. It is a situation that will require explanation: The application we are running requires SQL 2000, but there is a second app running on the server which needs sql 2008. So SQl 2000 was...
  10. bobpv

    How to use a variable to change the output filename

    Hello all, I am new to XML, and have looked for a solution in the list, maybe I am asking the question wrong. I have created a select in SQL 2000 to output data to a folder. All is working fine. Sample below: sp_makewebtask @outputfile = 'C:\ Hot Folder\filename.xml', @query = ' select...
  11. bobpv

    Trouble getting a count of a field.

    I am running in circles with this one, perhaps someone can point me in a new direction. It is a MSSQL data base which stores estimate data in a single table. Each estimate has a unique number as it's ID. An estimate can be related to additional estimates by a field called MASTER, which is the...
  12. bobpv

    Trying to get a date field to correctly filter from a parametr

    markros, it seems to be working just fine for my needs, it is allowing the items that were entered with a date of (example) 2009-01-16 12:31:000 ( yes I know my format on the date time field is wrong!but just an example for discussion))to be displayed when CR passes the parameter of...
  13. bobpv

    Trying to get a date field to correctly filter from a parametr

    pwise, that dateadd worked. I guess it was the old 'forest for the trees' syndrome, I was not thinking about that use for dateadd. Many thanks, I am much obliged.
  14. bobpv

    Trying to get a date field to correctly filter from a parametr

    Greetings all, I am really at a loss here, seemed like it should be simple, but up against a brick wall. Running a SQL stored procedure (SQL 2000)with several unions for a Crystal Report. Due to the large amount of data in the database, I am filtering the info in each union with an IN...
  15. bobpv

    Can a year or Month be updated in a date field?

    Sweet! Like a charm, many thanks. I was going about it from a wrong point of view. I really appreciate the assist!
  16. bobpv

    Can a year or Month be updated in a date field?

    Greetings, I want to try to update some date values in a test database on SQL 2000 server. I would assume that this would work: update JobTable set datepart(yyyy,jobdate) = '2009' But no, syntax error Incorrect syntax near '('. I have tried a few other ways, with again no success. Perhaps...
  17. bobpv

    Can I use getdate() in where filter, without time?

    Not sure why, but I was using the exact expression and not getting any return. Once I did the variable, it seems to work fine. I appreciate the advice and MANY thanks.
  18. bobpv

    Can I use getdate() in where filter, without time?

    Hello all, I have a SQL database and am writing a query to return records based on a date. This is desired to be automated, so each time it runs, it looks at past date date. Problem is the SQL data is stored without the time portion. So it's '2008-05-19 00:00:00.000'. Or course, getdate()...
  19. bobpv

    How to extract information from a string that may vary in size

    I have a string created by a formula to replace some words in the string, so it looks like this: W~1~1~1~SHW~1~5.5~1~1~ Each of the numbers shown between the ~ can be 2 didgit, with the 5.5 also can be 2, plus one dec place. The alpha characters (W and SHW) will always be 1 (W) or 3 (SHW). I...
  20. bobpv

    Using a formula to pull from a field with XML as the source

    Greetings all. Working with Crystal 10 and a progress database (ODBC Connection). There are 2 fields which hold the saleman code number and another with commission rate. Problem is the field can contain more than one salesrep and the 2nd can hold matching commission rates. Example...

Part and Inventory Search

Back
Top