Update YourTable

Set YourDate = DateAdd(D, 1, YourDate)

Select min(ID) as ID, PathwayID

From YourTable

Group By PathwayId

Order By ID

As Remi has hinted, his solution will allow the use of an index that may exist on trans_date.  Using a function on the column such as MONTH(trans_date) will not...

In the Query Analyzer you can execute sp_who or sp_who2

You can also check out this thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=184838

Using the DATEPART function will not allow the optimizer to use the index on the reortsentdate column so your statement will force a table scan.

For more info on how to...

That's what Remi gave you (and a little more).

Declare @StartD as datetime

declare @EndD as datetime

declare @Year as int

set @Year = 2004

set @StartD = dateadd(YYYY, @Year - 1900, 0)

set @EndD...

Or you could do this:

INSERT INTO dbo.[Receiving Inspection Header] ([Receiving Log No], [Lot No], [Part Id])  VALUES (@Receiving, @LotNo, ISNULL( @PartId,1) )

Select @PartId = ISNULL(Max([Part ID]),0) + 1 from [Receiving Inspection Header] where [Receiving Log No] = @Receiving And [Lot No] = @LotNo

As Frank mentioned your front end is most likely passing in some default value so just explicitly set the date to NULL when the user has not entered a...

"...WRenteredDate BETWEEN '2005-04-03 00:00:00' AND '2005-05-20 00:00:00'..."

Plesase note that BETWEEN is inclusive so unless you really intend to include rows with a date of...

Please see my answer in this thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=183974 which is a duplicate.

Point well taken.  But what does that mean when it comes to using stored procedures?  Do we not use them?

By default any comparison to null using =, <> etc. will always compare as false.  When comparing to null try to use IS NULL or IS NOT NULL.

For...

Merge Join is a Join HINT not a join type.

From books online:

H. Use HASH and MERGE join hints

This example performs a three-table join among the authors, titleauthors,

and titles...

From Books online (From Clause):

< join_type >

Specifies the type of join operation.

INNER

Specifies that all matching pairs of rows are returned. Discards unmatched rows from...