Mike C (3/26/2008)

---

Yes, performance enhancements would be welcome, but OTOH I can just imagine the complexity involved in doing what CROSS APPLY does. Hopefully they'll begin finding opportunities for optimization...

Adam Haines (3/27/2008)

---

This will only work if you use a group by in your query. You cannot perform aggregate functions

without a group by,...

Jeff Moden (3/27/2008)

---

Heh... no, you're right, Matt. I was just anticipating the next possible question (I should probably get out of the habit) which usually turns up as either...

Interestingly enough, they have the exact same type of document for 2005...

http://www.microsoft.com/sql/editions/enterprise/comparison.mspx#E4B

You're right though. Both documents are VERY slanted to show Standard edition in a negative light, or so...

MSDE 2000 can be installed and run in...

The OUTPUT clause is in the wrong place, too. that's one of the causes of your error.

It goes AFTER the affected columns list.

CREATE PROCEDURE [dbo].[Employee_Add]

...

Well - I wouldn't use either. I agree with Grant that a BREAK is not a great way to code it, and...#2 is wrong altogether (if you test for...

Like michael mentioned, it sounds like you're going to need to use some aggregate function to get rid of your "dupes". Since you ARE in access - perhaps consider...

Mike C (3/26/2008)

---

Matt Miller (3/26/2008)

You're right, XQuery does have a slightly higher learning curve than many other newer features in SQL Server 🙂 The CROSS APPLY and .nodes() method...

Since you're using a derived column transformation before throwing it into the destination, that's the place you can tackle dropping out the invalid time markers. Same as described before...

There are several very decent articles giong over how to build rather complicated SSIS data flows, right here on SSC.

http://www.sqlservercentral.com/Articles/SQL+Server+2005/SQL+Server+2005+-+SSIS/%5B/url%5D

One of the better ones as to being a step-by step...

Isn't casting to a number (as was previously mentioned) the easiest AND fastest way to do this? Even if you have to cast it back to a char(15)? ...

Christopher Ford (3/26/2008)

---

The light finally went off...

for each "section" I need to cross apply it to do what I want.

Example below:

SELECT

x.value('UnparsedName[1]', 'VARCHAR(20)') as Name

,l.value('@BusinessType', 'varchar(20)') as BusinessType

,CAST(CONVERT(varchar(20),l.query('HighBalanceAmount/text()')) as money)...

What do you know - I actually gave the MS developers credit that they wouldn't just leave us hanging like that. ...

Kenneth Fisher (3/26/2008)

---

Yea I saw alot of postings about it related to SQL 2000 but nothing related to SQL 2005. And I can't find anything on the previous error...