Search results for query: *

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

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

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

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?

I have count statement but for graph purposes I need to show the count number when it is 0. ATM it only shows if it has counted 1 or greater. Below is my code. select count(*) as Total_Resolved , cast(year(HE.Entry_date)as char(4)) + cast(CASE WHEN LEN(rtrim(cast(datepart(wk...

Hi, Got given a problem to look at and im a bit stuck. need to get a running total from the last 12 months to show progression. Below is the code which was already in place to show data per month and the code in the *** is what I have tried to do. I have tried lots of different combinations...