gregory.anderson (4/21/2010)

---

And when I comment those two case statements out and just put 2 @False values for those fields the insert works fine.

Edit: It's getting wierder (is that a word),...

Since there is no error message posted I'd assume you need to set the collation for the MI alias used to compare against your subquery too:

and(RTRIM(LTRIM(MI.CLNT_MATT_CODE)) COLLATE SQL_Latin1_General_CP1_CI_AI NOT IN

(SELECT...

Nope. You'd have to use an intermediate table to hold the results (either SELECT INTO or INSERT...

Yes, you'd need to declare namespaces.

There are several ways to shed some light on it:

1) have a look at BOL (BooksOnLine), section WITH XMLNAMESPACES.

2) search this site for "XML Workshop...

Would you mind telling us the business reason behind it?

Usually, the order of similar elements/sub-nodes within a node level is irrelevant.

What is the reason you don't want to use T-SQL?

You could add your ACCESS db as a linked server and use it like a SQL Server database.

See BOL, section "linked servers [SQL Server], Access databases" (BooksOnLine, the SQL Server...

gregory.anderson (4/20/2010)

---

If I read this right, we can go ahead and get rid of both the temp tables that we are using and just use the PermitsInserted table to track...

gregory.anderson (4/20/2010)

---

Ok, back to the fun...

How does this code block work (the MAX part) when it is going to return a non-integer value for the error mesage?

MAX(CASE WHEN Recordindicator =1...

Ooops, sorry for the misunderstanding... :blush:

Great article series, Paul!

It was a pleasure being selected to get a preview and to give some thoughts/comments.

Let's see how long it takes until I have referenced those two articles...

"Soon" has been recently?

See here or...

Please have a look at the CrossTab article referenced in my signature. Once you know how that works you probably should go to the "next level", DynamicCrossTab, referenced in...

Edit: post removed.

Content: Side effect of the "wrong quote bug", part 2.

Was funny just for the moment...

May I ask for the business reason for that requirement?

It sounds like a denormalized table (e.g. a monthly summary table with one column per month...)...

Edit: post removed.

Content: Side effect of the "wrong quote bug", part 1.

Was funny just for the moment...