I am building a website for our fishing club and developing a module for allow users to register their fish. I need help with a stored procedure that will return the fish a individual angler registered that day. Here is what I have so far:

create procedure YourCompanys_GetRegisteredFishToday
 @ModuleId int
as

select ModuleId,
  ItemId,
  Species,
  FishLength,
  Points,
  CreatedByUser,
  YourCompanys_FishScores.CreatedDate,
  'CreatedByUserName' = Users.FirstName + ' ' + Users.LastName
from YourCompanys_FishScores
inner join Users on YourCompanys_FishScores.CreatedByUser = User.UserId
where ModuleId = @ModuleId
 and YourCompanys_FishScores.CreatedDate >= DATEADD(day,DATEDIFF(day,0,GETDATE()),0) AND
  YourCompanys_FishScores.CreatedDate < DATEADD(day,DATEDIFF(day,0,GETDATE()),1)
GO

The problem is I keep getting this error:
System.Data.SqlClient.SqlException: Cannot call methods on nvarchar. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure YourCompanys_GetRegisteredFishToday @ModuleId int as select ModuleId, ItemId, Species, FishLength, Points, CreatedByUser, YourCompanys_FishScores.CreatedDate, 'CreatedByUserName' = Users.FirstName + ' ' + Users.LastName from YourCompanys_FishScores inner join Users on YourCompanys_FishScores.CreatedByUser = User.UserId where ModuleId = @ModuleId and YourCompanys_FishScores.CreatedDate >= DATEADD(day,DATEDIFF(day,0,GETDATE()),0) AND YourCompanys_FishScores.CreatedDate < DATEADD(day,DATEDIFF(day,0,GETDATE()),1)

  

Thanks for the response Sebastian.
Here is my table definition:
    [ModuleID] [int] NOT NULL,
    [ItemID] [int] NOT NULL IDENTITY(1, 1),
    [Species] [nvarchar] (10) NOT NULL,
    [FishLength] [float] NOT NULL,
    [Points] [int] NOT NULL,
    [CreatedByUser] [int] NOT NULL,
    [CreatedDate] [datetime] NOT NULL

What I am trying to accomplish is that when the User registers a fish it populates a gridview so they can see all of the entries they made that day. It also will give them the opportunity to delete any mistakes they may have made. So if the user registers 3 fish the gridview will list all 3 of their enties but nobody elses.
Hope this makes sense.

OK I implemented both of your suggestions and it is working very well! Thanks,