Yep, that is what I was hoping would happen.  Should I just use a table to store the value if I want it to persist?

Nevermind, I see what it is for.

I'm confused about splitting the list values.  Why is this done?

Remi, can you walk me through your solution?

From my understanding, every selected field must be part of either the GROUP BY clause or an aggregate function. Can you provide some sample data to explain which field...

What about having a second table (ProductSort) that stores your specific sort order...

Product_ID     SortOrder

     31                1

      5                 2

      7                 3

      9                 4

     12                 5

Then do your SELECT statement like this...

SELECT * FROM...

Hi,

Does your unique ID have to be an incremental integer type?  If not, I would just concatenate the values of SetCode, SubjectCode and YearCode to generate a unique...

Here is another dynamic SQL option...

1. Create a temp table that has an identity column (RowNum) and an integer

column (IndValue).  

CREATE TABLE #TempTable (

 RowNum int Identity (1,1) Not Null,

 IndValue int Not...

Hi,

I would recommend storing all of the shift information in one table adding a field called shift status (with the possible values of worked, cancelled or open).  If you have to use...

Here's how I did it using a cursor..

CREATE TRIGGER [SendErrorNotification] ON dbo.ClickonError

AFTER INSERT

AS

DECLARE @edit varchar(15)

DECLARE cedit CURSOR FOR

SELECT EditNumber

FROM INSERTED

OPEN cedit

FETCH NEXT FROM cedit

INTO @edit

WHILE @@FETCH_STATUS = 0

BEGIN

--add the...

Hi,

You're right.  It seems like a catch-22.  I was trying to grant permissions in the stored procedure but the user/role doesn't have the rights to assign permissions.

Ooops.  Forgot that I wanted to calculate age from @RptDate, not GetDate().

This works:

SET @strSQL = @strSQL + ' CAST(DateDiff(d,CS.AdmSrvDate, ' + '''' + CONVERT(varchar,@RptDate,101) +''''+ ') AS nvarchar(5)) END'

Thank you, Frank!  This worked:

SET @strSQL = @strSQL + ' CAST(DateDiff(d,CS.AdmSrvDate,  GetDate()) AS nvarchar(5))'

The larger statement as a whole needs to be dynamic. I'm using a stored procedure as a datasource for a Crystal report.  The joins in the SQL statement need to change...

Thanks!

What if I want to use a variable in the DTS, for example, @RptDate, instead of GetDate()?

Brenna