Been there, done that.  Welcome to the team .

Only one allergy can be applicable at any time?  Do you stop being allergic to peanuts once you become allergic to milk?

Please post the link here for further referrences.

You must list the columns you want to insert in the 2nd table.  You must figure this list out yourself or give us all the info so we can build...

Select * from dbo.TableName where valid_from <= @Date

The top 1 would limit the results to one row, which is most likely not what is wanted in this case.

I meant the whole insert statment... I'm sure most folks smart enough to use searh engine are also smart enough to use books online

Ya, those big concatenated queries are often full of surprises like this one .

Oops. Remove the dbo. before the deleted table.

Try this

if @TermID IS NOT NULL

begin

...

end

IF @TaughtCourseID IS NOT NULL

begin

...

end

Cancel my previous request.

IF EXISTS (SELECT * FROM dbo.SysObjects WHERE Name = 'ConcatDemo' AND XType = 'FN')

 DROP FUNCTION dbo.ConcatDemo

GO

--Function to concatenate

CREATE FUNCTION dbo.ConcatDemo (@TableId INT)

RETURNS VARCHAR(8000)

AS

BEGIN

 DECLARE @Return AS VARCHAR(8000)

 SELECT @Return...

Why are you even using a cursor or a loop to do this?

Please post the tables' definition, some sample data and the required output from that sample data specifying weither you...

CREATE [UNIQUE] NONCLUSTERED INDEX IX_Name ON dbo.TblName (Col1, Col2) ON FileGroupName

If you were to do this with the clustered index, the whole table would be moved to this filegroup (not...

I see your concern, but what good is the list of procedures if they can't gain access to them?  I'd like to hear your thaughts on the process as a...

SELECT  CASE WHEN [Module] = 'Soarian Clinicals-Classroom Instruction'        then [Module]

         ELSE rtrim([Module])+'(Online Module)'

      END  as ModuleName

 FROM   [Module Name List SClinicals]

CREATE TRIGGER TR_Audit_TblName_A_U ON dbo.TblName

FOR UPDATE

AS

SET NOCOUNT ON

INSERT INTO dbo.AuditTbl (ColsList)

Select ColsList FROM dbo.Inserted

This would send the new data inserted in the table.  Change Inserted to Deleted to have the...