Search results for query: *

Thanks for that, works a treat

Hi, I am usuing a formula if (month({FutureDate}) = (month(currentdate) + 1)) and (year({FutureDate}) = year(currentdate)) then "Y" else "N" And this works for 11 months of the year but I remember last year this didnt work due to the year(currentdate) part of the formula and I never got...

I may have just found a way. I changed the date to text and added it to the item number in a formula and grouped the report by the formlua. Hopefully this is reliable.

I am after a report which count the number of items which have 2 of the same fields, eg date of delivery and item number, so I can see if any duplications are made. Any help will be much appreciated, I am using Crystal 11.

I am uploading a csv file to an SQL database, but its coming up with errors because the incident number, which is a primary key in the database, is used in more than one of the records. I only need to enter 1 of the incident numbers records to the database as it is used as count to produce a...

Thanks, much appreciated

Hi Simi, I have 1 table and I need to create a 2nd table with the 1st tables data. Thanks

I need help updating an old table data to a new table. the field sare the same for both tables shown below and the table names are SRW_Incident and SRW_Incident2. I have tried a couple of things but nothing seems to work. Any help would be appriciated. Thanks Incident_No int Unchecked (pk)...

Hi Guys, Still cant find the problem. I did find that instead of putting -1 in the date add part I can put -3 and it shows this months data. If i put -4, it errors, so I think it could be somthing to do with the days or months of the date. WHERE (Date = CONVERT(char(10), DATEADD(dd, - 3...

Jamfool - No I dont get an error gmmastros - Thanks for the info

I found 2 records which have blank statdeldte. Can blank date be causing the issue. p.s Thanks to everyone who is helping me, it is appreciated.

Hi Jamfool there are over 2000 rows, so will get searching and hope I find it near the top. I ran your query SELECT ISDATE([GRN Posted]) AS Expr1, [GRN Posted], ISDATE(StatDelDte) AS Expr2 FROM dbo.ZSPO AS invo WHERE (ISDATE([GRN Posted]) = 0) OR...

Hi Jamfool, I ran your code and it did run but threw up an error. Once i okayed it, it ran, I had a look through the data and it seems ok. The error message came up on record 18432, below is a section of the data. As for being nasty code, i can see why the guy left who wrote it as I am having...

Someone wrote the below code to run in SQL server 2005. For some strange reason after months of running fine it comes up with the error "The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value" The sql code is needed to run a crystal report...

Fantastic, just what I was after. Thanks a lot

I need to group by date but the format of the date is date time so is coming out like 23/01/2009 14:05:52 I need to get rid of the time, what function can I use to delete the last 10 character?

Hey Jamfool, managed to get the crystal report working as well. It seemed that the stored proccedure needs to be created first and then the report, not visa versa. Thanks for your help and effort, it is appreciated. Kind Regards

Thanks very much, the code does work, but a problem has occured with Crystal. I get a "Failed to retreive data from the database" "Invalid Argument Provided" I dont understand why its not retrieving the data as it runs fine in SQL server. Dont suppose your a crystal expert as well :)

I found this link, im going to see if i can decipher it and use it. Will keep you posted with my results. If you can figure it out your more than welcome to help me again :) Thanks http://lichao.net/eblog/how-to-display-0-in-conditional-group-by-report-in-count-sql-query-200808164.html

I tried the code with the Select Distinct and I tried to run the stored proceedure and i it was executing for 3 minutes, then I cancelled it. I then tried it with just select and it ran but was pulling out duplicate records. Also I noticed that the date that you suggested isn't showing yyyyww...