I think Lowell's right here. There are an infinite number of solutions to this problem that don't involve using TSQL at...

On the dime.

Would it be totally out of the question to just open a ticket with the MS SQL CSS folks at this point?

Do you want to exclude rows where the value is 'SC'? Or do you only want the rows where the value is 'HK'?

Rob's query will return 2 rows in your...

The reason SQL Agent reported success is you're not failing the package when that step fails. In your package, on the Control Flow tab, click on your Data Flow...

I don't need no instructions to know how to rock!

Edited to add a link...

Head Games

You just posted to tell everyone "Here's a problem I had, here's what I...

I'm going to have to start with a couple caveats.

1) I don't really have any experience with SSRS.

2) I'm not really sure if it's better but we used this...

Lynn, thank you very much for the detailed reply. Ya learn somethin' new everyday 😉

SQLRNNR (8/7/2012)

Scott D. Jacobson (8/7/2012)

JAZZ Master (8/7/2012)

Daniel Bowlin (8/7/2012)

opc.three (8/7/2012)

JAZZ Master (8/7/2012)

Scott D. Jacobson (8/6/2012)

Rob Schripsema (8/6/2012)

Fits...

From talking to various HR people over the years, nay even actual IT interviewers (people in IT who actually conduct interviews and/or make hiring decision) I've heard something that may...

Should not be an issue. .NET frameworks are backwards compatible. However, like SQL Server, some features may be removed moving forward. There were certain features in 1.1...

Do you have any more material on this or is it purely anecdotal? For instance, what's wrong with this?

SELECT Col1,Col2,Col3 FROM SomeTable WHERE...

JAZZ Master (8/7/2012)

Daniel Bowlin (8/7/2012)

opc.three (8/7/2012)

JAZZ Master (8/7/2012)

Fish...