Sure,

I'd like the output to be like this.

Name | Oct 2010 | Nov 2010 | Dec 2010 | 2010 Total | Jan 2011 | Feb 2011 | Mar...

Jeff,

Great article, thank you.

I have a quick question - is it possible to have a total column for each year if the date range spans multiple years?

Everybody - thank you very much for the great suggestions.

Eralper - I went with your one because it suited my requirements the closest.

Thank you for your replies.

Eralper - I would like the function to return one record not a record per split word.

Chris, thanks for the reply. Here's a small sample

QualificationsLength

DepthMustBeNumeric

HeightMustBeNumeric

WidthMustBeNumeric

DepthNotValid

HeightNotValid

QuantityIsMandatory

QuantityNotValid

WidthNotValid

FactorNotValid

DimensionNotNumeric

DimensionNotValid

StartDateEarlierThanCurrentDate

CostCodeIsMandatory

QuantityMustBeNumeric

InvalidRatioNumeric

MissingRatio

Is that a recommended practice?

quote:

---

set @sqlstring = N'select * from ' + @DBName

---

Silly question, but what's the significance of...

OK still can't get it to work. Here is a simular example of what I'm doing using the Northwind database.

This is the proc I'm executing

exec crosstab2 'select top 20 shipvia...

stax68 - thank you, could you show me what you mean please?

Oops, sorry about crosspost.

Thanks for the help, I just figured it out also.

Fixed it myself. I forgot to add this to my command object:

.Parameters("@Quantity").Precision = 7

.Parameters("@Quantity").NumericScale = 2

.Parameters("@Discount").Precision = 5

.Parameters("@Discount").NumericScale = 2

I've been using SQLDiff by Lockwood http://www.lockwoodtech.com/index_sqldiff.htm

I found SQLCompare very slow.