Sound to me like a job for SSIS to clean the data prior to processing

Anyone kind enough to do a spot of proof reading / editing for my article for

http://www.sqlservercentral.com/Forums/Topic1012017-2824-1.aspx

TIA

You will have to be careful of collation issues but

between 'C00' and 'C14ZZZZZZZZZZZZZZZZ'

will do what you need.

Always worth considering a proper calendar table too..

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Ill take this one..

Ahh, making me nostalgic for the joys of dBase 4. Now that was one hell of a way to ruin a company.

Try using MERGE, you can with that.

http://sqlblog.com/blogs/jamie_thomson/archive/2010/01/06/merge-and-output-the-swiss-army-knife-of-t-sql.aspx

Its most likely do to with the use of the variable in the IN clause.

You are now asking

WHERE ParentRecordId in ("1,2,3,4,5,6")

So you will only get a...

A slightly different approach,

uses this technique http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/sql-and-contiguous-data-ranges.aspx to build a new non-overlapping list of ranges first.

I would be interested in comparative performance over a larger dataset. 😉

Drop Table #NewRanges

go

Create Table...

Homework surely ???

I always suspect that on employee / student related table , or is it just me ??

Stefan Krzywicki (10/14/2010)

Kit G (10/14/2010)

Neato!...

As the error states you are attempting to insert an explicit value into the Job_Title_ID column.

As this is an identity column , you should not have to do this.

I would...

It depends 🙂

Both are sargable, depending on the data being selected and the estimated rows

Try this, commenting and uncommenting the different insert statements

IF OBJECT_ID('Tempdb..#sargTest') IS NOT NULL DROP TABLE...

Apologies , ive lead on quite a bad steer here.

I originally read your query as

where ltrim(rtrim(Colname)) like @param

its not its

where colname like ltrim(rtrim(@param).

I am assuming that you have an...

From what you have said so far, the difference sounds...