Problem Using DateDiff To Calc Period

Jan 24, 2006

Hi people. I hope you can help with this. It has me completely stumped.
I am trying to get SQLS 2000 to calculate days between dates, without any success at all.
The two dates are as imported from a text file, and are as follows: -
(@issueddate=) 3/01/2006 3:37:00 PM
(@completiondate=) 04-FEB-2006 18:00

I cannot do much about the date formats, as they are as received from another party, as an email attachment.

I have tried just about everything I know to get this working, even tried commenting out each line till practically nothing is left, and still get the same message. Have also deleted the procedure and recreating it.
I have tried removing "PM" from the first date; tried changing varchar to datetime; tried using 'dd' instead of 'd' in the DateDiff function
Because of the "Aborted" response in Query Analyser, nothing is returned, and yet the Query Analyser's "Execute"
Command reports it completed successfully.
Should I ignore this "Aborted" response altogether and assume that it works?
Is it a known bug in SQLS 2000?

Here is the Stored Procedure:
----------------------------
CREATE procedure proc_calcDeadline
(@issueddate varchar(30)='',@completiondate varchar(30)='',@return int=NULL output)
as
declare @Period int
--set @issueddate='3/01/2006 3:37:00 AM'
--set @completiondate='04-FEB-2006 18:00'
set @period=datediff(d,@issueddate,@completiondate)
--print 'period=='+cast(@period as varchar)
set @return=@period
return @return
GO


The DEBUG response in Query Analyser is as follows: -

"Aborted"

[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
When I make changes in Query Analyser, (ie, "Alter Procedure', etc" then select "EXECUTE" option
the response is: -

"The command(s) completed successfully."



PS I am STILL unable to get fully into Query Analyser for step-by-step processing, even though I created the database on a single workstation (and therefore am the dbowner, with full Admin rights).

(Homesick for VBA territory, where I can get date calcs like this done easily!!)

Lester Vincent
Sydney

View 5 Replies


ADVERTISEMENT

Calc DateDiff In Workdays Only, No Holidays Either

Mar 26, 2008

I use the NETWORKDAYS(start_date, end_date,holidays) function in Excel and Access regularly. I'm trying to find a similar function in TSQL to use on Server2005. NetWorkDays allows me to calculate the difference between my ticket open and close dates while excluding weekends and holidays, (we are nice to our staff and let them off).

I'm trying to find an easy way to do this in TSQL without writing a large amount of code.

I will greatly appreciate any help.

View 1 Replies View Related

AVG CALC

Feb 10, 2006

New SQL - but certainly enjoying the experience.

I need to calculation an Average in SQL -

A view I created contains:

Item WorkOrders TotalProduced
A 10 125
B 1 10
C 3 48

Desired Results
Item AVGPRODUCED
A 12.5
B 10
C 16


The view will be used by a Crystal Report so I could calculate in Crystal - But I was wondering how to in SQL

Any help would be appreciated

View 6 Replies View Related

Calc A % Of A Summary Total

Jun 29, 2007

I have a report that requires 2 "tables". The first table summarizes total
lbs by a category and then provides a company total at the end:

cat 1 75
cat 2 100
cat 3 200
-------
total 375

The second table needs to display the % of the total for each category:

cat 1 20%
cat 2 27%
cat 3 53%
-------
total 100%

How can I reference the company total for doing the calculations for the
second table? I am working with Visual Studio 2003. My dataset pulls a
file from the AS400 using an sql statement.




Thank you, PB

View 4 Replies View Related

Calc Free Space In Datafile

Apr 6, 2005

hi,

I'm trying to calculate how much unused space i have on one datafile. My main goal is to determine the max space i can save by doing a dbcc shrink.
Any help is greatly appreciated.

ThanKs in advance.

Al

View 1 Replies View Related

Last Period As Initial Value But Still Have Period As Parameter?

Jan 3, 2007

Hi all,

I'm using an olap cube in a report (dash board).
The last "actual" period should be viewed when the user opens the report. I'm using the MDX tail function for that.
Once the report is opened the users want to select another period. Then I want to put period as a parameter.
But that is not possible since the parameter check box is no longer available when using a MDX filter expression.

Is there any solution to this problem?

Any help will be appreciated.

View 34 Replies View Related

Transact SQL :: Calc Work Date Using Business Days Field In Calendar Table

May 19, 2014

I created a dbo.Calendar table that stores dates and a work day flag (1=work day, 0=non-work day) so I can use it to calculate the next business date from a date using a function. I'm using a while group to count only the work days and a couple other internal variables but I'm not sure if I can even use them in a function.

Assuming Sats & Suns are all non-work days in April 2014, if my @WorkDays = 10 for 10 work days and my @DateFromValue - 4/1/2014, I would expect my return date to be 4/15/2014.

------ Messages after I click execute on my query window that has my function ------------------------------------------------------
Msg 444, Level 16, State 2, Procedure FGetWorkDate, Line 19
Select statements included within a function cannot return data to a client.
Msg 207, Level 16, State 1, Procedure FGetWorkDate, Line 20
Invalid column name 'WorkDay'.
Msg 207, Level 16, State 1, Procedure FGetWorkDate, Line 22
Invalid column name 'Date'.

------ my function code ----------------------------
CREATE FUNCTION [dbo].[FGetWorkDate](
    @WorkDays VARCHAR(5),
    @DateFromValue AS DateTime )
    RETURNS DATETIME

[Code] ....

View 10 Replies View Related

Can A Calc'd Query Column Be Compared Against A Multi Value Variable Without A Nested Query?

Nov 15, 2007

do i need to nest a query in RS if i want a calculated column to be compared against a multi value variable? It looks like coding WHERE calcd name in (@variable) violates SQL syntax. My select looked like

SELECT ... ,CASE enddate WHEN null then 1 else 0 END calcd name
FROM...
WHERE ... and calcd name in (@variable)

View 1 Replies View Related

Datediff

Dec 5, 2005

If I wanted to get everyone DOB who is over 18 how would I do that? I am currently trying something like this, but no luck...


Declare @todays_date datetime

Select from person
CASE
WHEN dateadd(year, datediff (year, Date_Of_Birth, @Todays_Date), Date_Of_Birth) > @Todays_Date -- Date of Birth check
THEN datediff (year, Date_Of_Birth, @Todays_Date) - 1
ELSE datediff (year, Date_Of_Birth, @Todays_Date)
END
>= 18

View 3 Replies View Related

DateDiff

Jul 27, 2004

I'm using a datediff(mi, start, stop) to get the duration of an operation. i want it displayed in HH:MM format. can anyone help me w/ a way to do that????



tia,
e3witt

View 4 Replies View Related

Datediff Or MAX?

Mar 9, 2004

Hello,

My string is:

SELECT weight FROM progress WHERE dateInput = (SELECT MAX(dateInput) FROM progress) AND memberID = 1

The problem is that the MAX dateInput doesn't belongs to memberID 1. It belongs to memberID 2. What I want is that I wanna choose the MAX Date of memberID 1. I thought of maybe using datadiff function. But I don't know how to make the datediff statement. Maybe I can write the datediff statement whereby the least datediff between the dateInput and getdate() will be the row I want. I really appreciate the person that helps me this problem... Thanks 1st of all!

View 2 Replies View Related

DateDiff

Apr 15, 2004

I am trying to select records from whatever the current date would be and 12 months before whatever the current date is. How would I go about doing this. The table that I am trying to do this with has a year column and a month column.

I was playing with the date diff function, but I can only get dates from the specified date range. I need it to be where if I run it tomorrow, it will get that day and everything within the last 12 months.

View 7 Replies View Related

DATEDIFF?

Apr 25, 2008

I need to get a listing of all persons who are atleast 18 years of age. A date of birth field in the database is in this format:

4/25/2008 12:00:00 AM

My solution would be where the difference between the current date and the dob is >= 18.

I tried...

select * from table where datediff(yy,dob,getdate)) >= 18.

But this only seems to subtract the years and ignore the days/months, which I need. Could anyone provide the syntax I need?

Help is appreciated. Thanks.

View 3 Replies View Related

Datediff

Jun 24, 2008

Hi there i am using the datediff funtion but it does not seem to be inclusive of the two dates eg
SELECT DATEDIFF(day, s_Date, e_date) AS NumberOfDays,*
FROM weekendtest

i know i could do
SELECT DATEDIFF(day, s_Date, e_date)+1 AS NumberOfDays,*
FROM weekendtest

but i was just wondering if there some other function i should use that would be more appropriate

View 3 Replies View Related

Datediff

Oct 21, 2004

Hi
I've a problem!!!
i want to use datediff thats no problem. But the first parameter has to
be parameterised. What datatype do i declare it as. i declare it as varchar
it returns me an error : Invalid parameter 1 specified for datediff.

i'm doing this in a stored procedure.

Is there a way out or do i've to use the good old 'IF' or 'Case' ?



regards
pradeep

View 1 Replies View Related

DateDiff In Sql?

Oct 19, 2006

Hi,
I have a Table Where I have Two Date columns and I want to find the Differnce in the 3rd column.ie DateReceived - AsOnDate = NoofDays.I tried this code
SELECT SRNO,CONVERT (VARCHAR,AsonDate,102)as ASONDATE,CONVERT(VARCHAR, DateReceived, 102) AS DateReceived,CONVERT(VARCHAR, DateAcknowledged, 102) AS NoofDays,
sum(CASE WHEN DATEDIFF(DAY, DATERECEIVED,ASONDATE, GETDATE())
FROM Details


Plz help me...

Thanks

View 7 Replies View Related

DATEDIFF

Jan 27, 2008

SELECT DATEDIFF(mm,0,'01/25/2008')
Returns 1296 what does it represent...

Thanks

View 2 Replies View Related

DATEDIFF

Feb 29, 2008

Could somebody please explain to me why I get the following results:


select datepart (ww, '10/02/08') --returns 6

select datepart (ww, '18/02/08') --returns 8

select datediff (ww, '10/02/08', '18/02/08') -- returns 1

I was expecting the third query to return 2.

Thanks.

View 11 Replies View Related

HELP Me In This Datediff() Function....

Nov 23, 2006

Hi, I am facing problem rite now.. I want to calculate the date different minutes between 23:00:00 and 01:00:00.
My code :
datediff(Minute,'01:00:00','23:00:00')
The result is 1320 minutes. (22 hours)... But, the result that I want is 120 minutes (2 hours)....
Can anybody help ???
Thanks in advance...

View 2 Replies View Related

Datediff Problem

Jan 12, 2007

I'm trying to use the same select statement I used in classic SQL, but it isn't working.  I get a "The server tag is not well formed." error.
I'm trying to return all the records where the date in a particular field are over 60 days old.  My select statement is:
"SELECT [ReNewAd], [Male or Female], [File2], [PHOTO], [First Name], [Last Name], [City], [State], [NewAd] FROM Members Where ('NewAd' IS NOT NULL AND (DateDiff('d', [NewAd], '" & Now() & "') <= 60)) order by [NewAd] Desc"
I've been looking through the datediff posts, but I'm not making any sense of what I'm reading.  Can anyone see what I'm doing wrong?
Thanks, Diane

View 5 Replies View Related

Using CASE And DATEDIFF

Jun 14, 2007

I'm trying to create a stored procedure that will return a set of data. An input parameter (if specified) will determine what topics will be show based on the date the item "datetime". ALTER PROCEDURE [dbo].[discussions_GetTopics]@board_id as int,@PageNumber INT,@TopicsDays  INT = NULL,@TopicsPerPage INT,@HowManyProducts INT OUTPUTAS-- Declare the table that will store all the topics for the given board_idDECLARE @Topics TABLE(RowNumber INT,topic_id INT,topic_title VARCHAR(50),topic_replies INT,topic_views INT,topic_type INT,post_id int,post_time DATETIME,Topic_Author_UserName nvarchar(256),Topic_Author_ID uniqueidentifier,Post_Author_Username nvarchar(256),Post_Author_ID uniqueidentifier)-- populate the tableINSERT INTO @TopicsSELECT     ROW_NUMBER() OVER (ORDER BY discussions_topics.topic_id), discussions_Topics.topic_id, discussions_Topics.topic_title, discussions_Topics.topic_replies, discussions_Topics.topic_views, discussions_Topics.topic_type, discussions_Posts.post_id, discussions_Posts.post_time, user_1.UserName AS Topic_Author_Username,                      user_1.UserId AS Topic_Author_ID, user_2.UserName AS Post_Author_Username, user_2.UserId AS Post_Author_IDFROM         discussions_Topics INNER JOIN                      discussions_Posts ON discussions_Posts.post_id = discussions_Topics.topic_last_post_id INNER JOIN                      aspnet_Users AS user_1 ON user_1.UserId = discussions_Topics.topic_poster INNER JOIN                      aspnet_Users AS user_2 ON user_2.UserId = discussions_Posts.poster_idWHERE     (discussions_Topics.board_id = @board_id ANDCASE @TopicsDays    WHEN '1' THEN DATEDIFF(day, discussions_Topics.topic_time, getdate()) <= 1    WHEN '2' THEN DATEDIFF(day, discussions_Topics.topic_time, getdate()) <= 7    WHEN '3' THEN DATEDIFF(day, discussions_Topics.topic_time, getdate()) <= 14    WHEN '4' THEN DATEDIFF(day, discussions_Topics.topic_time, getdate()) <= 30    WHEN '5' THEN DATEDIFF(day, discussions_Topics.topic_time, getdate()) <= 90    WHEN '6' THEN DATEDIFF(day, discussions_Topics.topic_time, getdate()) <= 180    WHEN '7' THEN DATEDIFF(day, discussions_Topics.topic_time, getdate()) <= 365END)-- return the total number of products using an OUTPUT variableSELECT @HowManyProducts = COUNT(topic_id) FROM @Topics-- Return the specified page of topicsSELECT * from @TopicsWHERE RowNumber > (@PageNumber - 1) * @TopicsPerPageAND RowNumber <= @PageNumber * @TopicsPerPage  I need help where the  "CASE @TopicsDays
    WHEN '1' THEN DATEDIFF(day, discussions_Topics.topic_time, getdate()) <= 1
    WHEN '2' THEN DATEDIFF(day, discussions_Topics.topic_time, getdate()) <= 7
    WHEN '3' THEN DATEDIFF(day, discussions_Topics.topic_time, getdate()) <= 14
    WHEN '4' THEN DATEDIFF(day, discussions_Topics.topic_time, getdate()) <= 30
    WHEN '5' THEN DATEDIFF(day, discussions_Topics.topic_time, getdate()) <= 90
    WHEN '6' THEN DATEDIFF(day, discussions_Topics.topic_time, getdate()) <= 180
    WHEN '7' THEN DATEDIFF(day, discussions_Topics.topic_time, getdate()) <= 365
END" Is...   Im not doing it right. Can someone help me?

View 1 Replies View Related

DateDiff / DateAdd - Please Help Me:(

Sep 28, 2007

hello,
i have a Pictures table:  PictureID, Name, Description, DateAdded (GETDATE() when insert), IsActive...
i need to make some stored procedures to show me the pictures added in last 24hours, in last 3 days, last 2 weeks and so on
the pictures added in database are active (available to be seen by users) only 1yaer after the date added
I tryied to make a stored procedure (in fact i maked a lots of them, for 1day 3 days 1 week 1 month), but i have a problem with that DateDiff and DateAdd
Here is what i tryied CREATE PROCEDURE LastAdded_2monthsAgo

AS

SELECT Pictures.ProductID, Pictures.Name, Pictures.Description, Pictures.DateAdded
FROM Pictures
WHERE (DATEDIFF(month, Pictures.DateAdded, GETDATE()) >= 0) AND (DATEDIFF(month, Pictures.DateAdded, GETDATE()) <= 2)
ORDER BY DateAdded DescI have a feeling that is wrong, please make your own version and show me what i should write...I don't know what should be first the today date or the DateAdded...i need to select the last added products from a specific interval of time...Should i do something with that "1 year available" like  WHERE (DATEDIFF(month, GETDATE(), DATEADD(year, 1, Products.DateAdded)) >= 0) AND (DATEDIFF(month, GETDATE(), DATEADD(year, 1, Products.DateAdded)) <= 2) I am sure is a stupid thig up there...if you can, make your own version how you would do it and show me..please help me

View 5 Replies View Related

Using DateDiff Function For Age

Nov 12, 2007

Hi,I'm using the datediff function to display the ages of the users in my database. However the age rounds up once they are 35.5 etc...I could create another function which works similar to the DateDiff function, but use math.floor to always round down, but I need to use this function in a SQL statement WHERE clause. Is there any way around this?Thanks,Curt. 

View 3 Replies View Related

Sql Server DATEDIFF

Apr 25, 2008

This is a sql question, so I'm hoping someone can give me some direction.
I need to query a table and return all rows where the individual is >= 18 years of age. It should involve simply subtracting the date of birth from the current date.  I thought the answer would be so simple:
 select * from table where datediff(yy,dob,getdate()) >= 18
Unfortunately, the results are inconsistent.  The DATEDIFF function, it appears, will not show correct results down to the month/day level.  I tried posting this on a sql server forum, but the recommendations I received involved coding some gigantic function.  It seems that there ought to be a simple 'WHERE' clause which could solve this.
If someone knows of a silver bullet, I would surely appreciate your advice.
Thank you.

View 5 Replies View Related

DATEDIFF In A WHERE Clause

May 6, 2008

I'm trying to include a DATEDIFF compare in my Where clause, but it seems to ignore the comparison I'm trying to invoke, and just returns all  rows.  When I display the result of the DATEDIFF  command, it looks good, but I can't seem to have it incorporated in my Where clause.
The following is my code -
 select [Pkg ID], [Elm (s)], [Type Name (s)], [End Exec Date], [End Exec Time]
from pkgactions
WHERE (8 > DateDiff(year, [End Exec Date], GetDate() ))
order by [pkg id]
 
Thanks

View 4 Replies View Related

DATEDIFF Possibilities

Aug 10, 2004

Hi,

I have two fields in one of my database table. They are date fields, one for the start and the other for the end of the "problem solving". What I want to do is to show the concrete elapsed time between the two.

My first problem is that I'm not able to show hour AND minutes. I wrote this for instance:
SELECT DATEDIFF(hour, fld_date_debut, fld_date_fin) As elapsed_time
I tried HH:mm instead of hour, but it is not working.

My second problem is that I can have more than one start and end hour for the same "problem solving". In the database it's like:

start hour: 10:00 End hour: 11:00 Number of the problem: 1
start hour: 13:00 End hour: 16:00 Number of the problem: 1

So I would like to add these to my elapsed time. I want (11:00 - 10:00) + (16:00 - 13:00)...but how can i do this in my SQL query ?

Thanks.

View 1 Replies View Related

DateTime Using DateDiff

Dec 8, 2004

Hello everyone.

Im currently using the DateDiff function to filter my DateTime columns but am finding it somewhat troublesome. Currently I am having to write the same select statement 3 times if I want to filter by month, year or all (ignoring dates).

To find @PurchaseTotal for the year, I have to write the following:


SELECT
@PurchaseTotal = Sum(PurchaseTotal)
FROM
_Expenses
WHERE
DateDiff(yyyy, DateOf, @IntervalDate) = @Interval



To find @PurchaseTotal for a month, I have to write the following:


SELECT
@PurchaseTotal = Sum(PurchaseTotal)
FROM
_Expenses
WHERE
DateDiff(mm, DateOf, @IntervalDate) = @Interval



To find @PurchaseTotal for all the records, I have to write the following:


SELECT
@PurchaseTotal = Sum(PurchaseTotal)
FROM
_Expenses


I've tried the following code but I get an error.

DateDiff(@DateParameter, DateOf, @IntervalDate) = @Interval

Error says something like "incorrect parameter 1 for DateDiff."

It seems you have to write a different select statement for month, day and year. Also If you want a total from all the records you have to write yet another select statement.

Does anyone know of a DateTime function that allows parameters to specify for month, day and Year? Also does anyone know of a DateTime function that works like the COALESCE function to where you can send it a NULL value and give you all the records?

Thank you ahead for any direction you can give.


Alec

View 1 Replies View Related

DateDiff Always Return 0

Feb 14, 2006

I just discover the result for my query that had use the function dateDiff seems to be in-correct, no matter what's the date, the dateDiff always return a zero. Am I using it in-correctly?
select DateDiff(mm,11/1/2004, 12/31/2005)
SELECT component_id, component_description,SUM(CASE DateDiff(mm,date_complete,'12/31/2004')WHEN 2 THEN component_qty ELSE 0 END) AS mm1,SUM(CASE DateDiff(mm,date_complete,'12/31/2004')WHEN 1 THEN component_qty ELSE 0 END) AS mm2,SUM(CASE DateDiff(mm,date_complete,'12/31/2004')WHEN 0 THEN component_qty ELSE 0 END) AS mm3,sum(component_qty) as totalFROM view_jobcomponent WHERE date_complete between '10/1/2004' and '12/31/2004' GROUP BY component_id, component_descriptionorder by component_id, component_description

View 1 Replies View Related

Problems Using DateDiff

Jun 13, 2006

Hi im having som problems using the dateDiff,
1. Im not really sure what row's to grap,
2.Im getting this error saying somthing like  : "None-spicefied Function GetDate"
"sry for the bad translation, im getting the error's in danish and my englich is not to good :)"
Any help would be very nice =)
   -----------------------------------   Code   -----------------------------------
This is my clas.

Function NewSearch () As DataTable
Dim objData As New DataAccess


Dim strSQL As String = "SELECT datediff(mm, GetDate(), Repair) FROM Used_Cars"

Return objData.GetDataAccess(strSQL, _strDatabase)
End Function
 
And this is my default.aspx.vb .

Protected Sub action_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles action.Click
Dim Search As New carFactory
Dim dtMaerker As DataTable
dtMaerker = Search .NewSearch ()
      For Each Row As DataRow In dtMaerker.Rows
           ' "Repair" contains som date's
            lblIndhold.Text = Row.Item("repair") & "<br />"
      Next
End Sub

View 6 Replies View Related

Datediff Queries....?

Aug 19, 2000

hi gurus,

can anyone tell me how to write a query which you could use like a hotel wakeup call system with an email sent instead of a phone call. the fields in the table would only be the target email address and date/time of the event. i suspect the query would run on a 10 minute meta-refresh asp page containing the email broadcast app along with the query.

thanks
szazo

View 1 Replies View Related

DATEDIFF And DATEADD

Apr 22, 2008

Hi
I'm trying to break down some code to work out how it's working. I've encountered DateDiff and DateAdd and I think this adds a new date of midnight today after reading up on the syntax (still dont fully understand how it works to be honest)

SELECT DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)

However, this is slightly different because where there is a 0 above there is a 13 in this one so I'm wondering what the 13 is actually doing.

SELECT DATEADD(dd, DATEDIFF(dd, 13, GETDATE()), 0)

In this one there's a 21

SELECT DATEADD(dd, DATEDIFF(dd, 21, GETDATE()), 0)

Can someone guide me please?

Thanks
Daniel

View 5 Replies View Related

DateDiff Problem

Apr 29, 2008

Hi Everyone
I have a table that stores information that is used to help monitor the issuing of safety clothing. I have a Transact SQL procedure that checks if a user has had an item within the last year. THe procedure returns values:

1 the item does not exist for any user so insert
2 the item exists but was issued more than a year ago so insert
3 the iem exists but was issued within one year so do not insert

I had some help from this forum initially and I thought that I had finally solved this problem but it still is not quite right. Please could someone take a quick look and point me in the right direction

CREATE PROCEDURE [DBO].[check_values]
@param_clothing_id int,
@empNo char(8),
@createdBy char(8),
@price decimal,
@qty int,
@returnVal int=0 OUTPUT
AS

SET NOCOUNT ON


/*First check if the record already exists*/
IF EXISTS (SELECT * FROM movement WHERE emp_no =@empNo AND clothing_id=@param_clothing_id )



BEGIN
/*Record already exists - So now check if it is less than a year old*/

IF EXISTS (SELECT * FROM movement WHERE emp_no =@empNo AND clothing_id =@param_clothing_id AND DATEDIFF(dd, create_dte, getdate())>366)

BEGIN

/*Record is less than a year oldso return a 3*/


SELECT @returnval=3
END
ELSE

/*Record older than a year so insert the record and return a 2*/

BEGIN


INSERT INTO movement
(emp_no,
clothing_id,
qty,
create_by_emp_no,
clothing_price)

VALUES(
@empNo,
@param_clothing_id,
@qty,
@createdBy,
@price)

SELECT @returnval=2
END

END
ELSE

BEGIN
/*Record does not exist at all - So insert the new record and return a 1*/

INSERT INTO movement
(emp_no,
clothing_id,
qty,
create_by_emp_no,
clothing_price)
VALUES(
@empNo,
@param_clothing_id,
@qty,
@createdBy,
@price)

SELECT @returnval=1
END
GO

View 4 Replies View Related

Using Datediff To Return Y Or N

Jun 12, 2008

Hi GUYS

I am trying to use the datediff function to return a Y if difference is greater than 0 and a N if difference is less than or equal to 0

select if datediff(dd,maturity_date,log_changed) > 0 'Y','N')

and i am getting a syntax error.Can someone show me where i am getting it wrong.

In god we trust,everything else we test.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved