David Webb-200187 (4/15/2010)

---

I'm in a position now where I am managing an outsorced DBA service. I'd like to be able to look at everything at the server and database...

Even if I'm not Jeff ( 😀 ) but promoting his great articles because those are simply the best ones I found related to this subject, I'd use ROW_NUMBER() to...

and here we go:

Short explanation:

a CTE (aka CommonTableExpression) is similar to a subquery, but just easier to read.

It can also be used to do some recursive joins. For details please...

gregory.anderson (4/15/2010)

---

The update of the conversionstatus statement isn't working how I want because it updates ALL of the records even though only 557000 of the 680000 are getting inserted (because...

First: Glad you like the solution (so far) 😀

Second: Sorry that I left yesterday without any further motice... It was 1am over here so I decided to take a nap...

What "user" does that say?

Are you sure you're talking about a SQL Server issue?

Please post sample data and what you're actually trying to do.

Sounds more like a front end issue...

What's the result of SELECT @@VERSION ?

If it's less than something like "Microsoft SQL Server 2005 - 9. ..."

then you're absolutely right. CTE's are not supported below SS2K5.

You might want to have a look at the CrossTab and DynamicCrossTab articles referenced in my signature.

The former will show you an example on how to build pivoted data with...

Maybe this link will be of some help, too:

http://www.sqlservercentral.com/Forums/Topic679572-338-2.aspx

Barry did a great job explaining how the STUFF ... FOR XML PATH actually works.

Edit: quote removed...

Did you try to put the semicolon right in front of the WITH keyword?

I can't see anything wrong at all with the query as it is posted. What...

Ok,

here's part 1. It should cover everything except the handling of (@PermitType = 'M')

I expect you have a test environment so you can verify if it will return the same...

Data are loaded. Working on it.

gregory.anderson (4/14/2010)

---

I did this because the previous conversion to get to the mainframe/VSAM version caused some bad data to be created. There are...

Well, this way of posting...

Ok,

here's what I found so far:

Data type mismatch: [PermitNo] [int] vs. [PermitNumber] [varchar](6)

Data type for @PermitType_Org, @PermitType_Ind, @PermitType_Temp, @PermitType_Sticker?

Any constraint on [Status] [varchar](2) to ensure 'RP','' or numeric values?

This...