J-F Bergeron (4/15/2009)

---

Florian Reischl (4/15/2009)

---

I'm not sure if I understood right...

If you try to use the SCOPE_IDENTITY() to get the id of your currently inserted record this is not correct....

Hi

LIKE '%[_]%'

What is the problem with the ESCAPE or CHARINDEX?

Greets

Flo

I'm not sure if I understood right...

If you try to use the SCOPE_IDENTITY() to get the id of your currently inserted record this is not correct. The SCOPE_IDENTITY() would return...

... and if you have to remove other...

don.craig (4/15/2009)

---

Hello I took your code and made the following changes to it

--Create Temp table to load converted data

Create Table #Temp

(

col1...

Hi

I also don't really understand the requirement. Do you mean that you want to append the filtered result with the unfiltered one? (What I still wouldn't understand 😉 ) If...

Please have a look to the link in my signature for explanation how to provide some sample DDL and data.

Thanks

Flo

Duplicate post: http://www.sqlservercentral.com/Forums/Topic697897-338-1.aspx

Hi

The answer depends on your future requirements. If it is just a temporary failure you can use COLLATE within the WHERE clause to specify the column as case-sensitive. If this...

Hi VJ

Thanks for that ;-). I try to keep in mind!

Have a nice day

Flo

Hi

I just confirm with Dan. In MySQL COALESCE is the way to go:

COALESCE(STATE, 'all')

Here a link to the MySQL reference where I just found this:

http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html

Greets

Flo

Hi!

I just can’t say how pride I am for all your laud!!

After I took all your hats back to the wardrobe I have to thank all of you. Those who...

Hi

As Vijaya Kadiyala already stated your XML is not valid for the specified XSD. This is no error in SSIS. Have a look for XSD attribute nillable="true" and XSI attribute...

Hi everybody

Sorry for my late answer but I had a busy day at work...

Thank you for all your investigations and your time!!!

I've not been lazy. I did many tests for...

Bruce W Cassidy (4/13/2009)

---

[font="Verdana"]I think the problem is that you want to order the columns not the rows.

Hmmm.

The only way I can think of off-hand is to unpivot, order, then...