G'day All,

Thank you for all of the discussion and suggestions.

The approach we have decided to take is to speed up development and deployment of the libary as a service.  We...

Ian and Mark,

Thank you!

Ian: This is exactly where we are today.  The vendor is requesting that we provide a DB so they can see end-to-end functionality before delivering the code...

"Given SQL Server" is correct

This is an internal system - not a product.  The production environment is under such tight control that I...

G'day,

The answer is "it depends".  Your problem description sounds like a classroom assignment, where the total volume of data, and users, is likely to be quite low.  A simple computed column will...

So here is challenge for the SQL Server Central community as a whole:

This board probably has more collective wisdom, experience, skills, and technical knowledge than any group of half a...

"Outer join conditions, however, may interact differently with the WHERE clause search conditions, depending on whether the join conditions are in the FROM or WHERE clause. Therefore, the ability to...

Practical reasons, actually.  One of my clients has a web app I support that uses random numbers as part of the mechanism to prevent spoofing and other related attacks.  Currently...

oooo...  This might get philosophical, although that is not my intention. 

I like to approach design from the "Normalize until it hurts, denormalize until it...

I agree with Remi,

Sounds like a join table is the proper solution.

Minerals (Min_ID, Min_Name, Image_URl)

Reactions (SReac_ID, SReac_Name)

MineralReactions (SReac_ID,Min-ID)

Wayne

Kevin,

Because this is a SQL server board, I assume there is a table of some sort you are querying?  Please provide DDL and sample data for the table.

Thanks

Wayne

Excellent!  Just what I was looking for.  Thanks Jo.

Wayne

SELECT @QueryWhere = @QueryFrom + ' Where ' + Cast('@AgreementSetId' AS VARCHAR)+ ' = AgreementSetId'

should be

SELECT @QueryWhere = @QueryFrom + ' Where ''' + Cast(@AgreementSetId AS VARCHAR)+ ''' = AgreementSetId'

and...

Thanks John!

Have a great day

Wayne

G'day,

This is without query analyzer, so check the syntax...

SELECT @Query = 'SELECT RebateId from Rebates '

SELECT @QueryWhere = ' Where @StartDt < RebateStartDate '

should be something like

SELECT @Query =...

Jo,

I have previously seen references to placing a filter on the join instead of in the where clause, exactly as you pointed out to Mario.  The assertion is that placing...