Search results for query: *

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

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

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

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

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'...

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

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

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.

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

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

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

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

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.

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

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

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

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.

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()...

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

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