Here are my modifications.

The hours can't exceed 250...total.

Create Trigger check_work_hours

On Assignment

After

AS

UPDATE Assignment

SET workHours = workHours

IF EXISTS (Select SUM(workHours)

...

Thanks

Thanks for the help everyone.

I am now referencing the parameter in the stored procedure as follows:

use master

GO

CREATE PROC spWhichTable

@ColumnName varchar(50)

AS

SELECT o.name as [Table], c.name as [Column]

FROM sys.tables o JOIN sys.columns c ON o.id...

--The procedure was created ok:

CREATE PROC sp_WhichTable

@ColumnName varchar(50)

AS

SELECT o.name as [Table], c.name as [Column]

FROM SYSOBJECTS o JOIN SYSCOLUMNS c ON o.id = c.id

WHERE c.name like '%order%' AND o.xtype...

--The procedure was created ok:

CREATE PROC sp_WhichTable

@ColumnName varchar(50)

AS

SELECT o.name as [Table], c.name as [Column]

FROM SYSOBJECTS o JOIN SYSCOLUMNS c ON o.id = c.id

WHERE c.name like '%order%' AND o.xtype...

Nevermind, I got some results with this exec:

Exec spDateRange '20060501','20060530'

I modified the parameter datatypes, stored procedure naming convention and added a rule to take into account the mindate = max date.

The procedure was created without errors.

If the parameters are...

I made some modifications to the code but cont to get an error message when creating the procedure. Here is the latest code and my error.

CREATE PROCsp_DateRange

@DateMin DateTime =...

ok, I added an imput parameter and removed the variable. I am still getting this error message when calling the procedure- Incorrect syntax near 'VendorID'.

CREATE PROC sp_WhichTable

@ColumnName varchar(50)

AS

SELECT o.name...

Works now....Thank you for your help.

Thanks for the help.

Its working now. 😀

Thanks for the help.

When I executed this query I received this error message:

Msg 8152, Level 16, State 14, Line 1

String or binary data would be truncated.

The statement has been terminated.

Is there a way to see the generated .Net code from SQL Server Studio?

I right click the table and see the script that SQL Server created for the INDIVIDUALS tabl...