You already have a temp table with the values you want. Why not use that and do:

IN (

SELECT RoleName FROM #Role WHERE @Role = 'ProjectManager'

UNION ALL

SELECT @Role)

Wouldn't that be...

Instead of the complex OR construct in your Where clause, you might try splitting it up into three queries, one for each parameter, and then using Union All to put...

It looks to me like you'll need to extract a sub-string of the Full Address that excludes any Zip+4 value.

You can do that with PatIndex and SubString functions.

Take a look at using a Sequence object instead of an Identity property. You can control Sequence values very easily.

Any reason to not just back up the database and then clean out the old data from the live copy?

A backup has the advantage of maintaining point-in-time consistency between tables,...

Image is a binary datatype. HTML is text.

Do you mean you have an image (a jpg, png, bmp, or similar) file stored as "image" datatype (binary), and you want...

I've designed lots of databases from scratch.

The most important part of the process is to remember that it has to be maintainable and extensible. "Clever" solutions are almost always...

The usual way to do that is to rebuild the clustered index into the new filegroup ("CREATE INDEX WITH DROP_EXISTING" is one way to do that, if I remember correctly).

The...

The performance on that might not be great, but it should work.

Better would be to have a typed column with Int data in it, but if you can't get that,...

Are you just talking about drilldown reports?

If you're on SQL 2012 or later (as per the forum the question is in), you can add Try_Cast or Try_Convert to the code.

Select CASE WHEN (TRY_CAST(ABS.VALUE AS INT)<90 AND...

Depends on what you mean by "average" with regard to a text field. Does that mean if one value is "A" and another is "C", it averages to "B"?

Jeff Moden (6/15/2016)

GSquared (6/15/2016)

Jeff Moden (6/14/2016)

GSquared (6/14/2016)

Jeff Moden (6/10/2016)

Eric M Russell (6/10/2016)

I'm not saying that string manipulation...

Nope. The Post function...

There really isn't a way to go back in time and truncate everything older than 30 days from the tran log.

And, yes, for companies using passive-audit techniques, there are times...