SQLPain (10/7/2015)

---

I tried putting the following directly in the select statement but it didn't worked either and gave me the error, when I run the statement independently it works fine...

Priya_learner (10/7/2015)

---

Thanks for the reply

I am able to split the 4 type of records using header Footer primary and detail file connections

but the thing is how to put them back...

Guess I'd better get another bottle of BBQ sauce. 😀

I wish there was a way to get back at those spammers. They won't stop until it costs them something.

dan.maddux (10/2/2015)

---

is there a way of doing this with multiple rows that vary in length? i have 6000+ rows that have variable text and need a hard break after...

shankley (10/1/2015)

---

I have a DistributorInvoiceNumber that can end with in 'R', 'A', 'CRR' or 'CR'.

I am trying to write a case statement like so:

CASE WHEN RIGHT([ih].[DistributorInvoiceNumber],1) = 'A'

...

Don't forget to ask where ALL the passwords are kept.

New question: Why doesn't SSDT plug into SSMS ?

Since when are we supposed to know why Microsoft does things the way they do? DUH!!! :w00t:

Sorry. Had to vent!...

mar.ko (9/30/2015)

---

Alvin, I don't understand that....

it has a powerful data table compare and auto scripting feature.

It apparently can take two tables and provide a script to make sure they are...

Why? Because that's not what it was designed for.

Checked your Linked Servers to see if a link to that server has been created.

I believe a table variable in SSIS would end up being a recordset stored in an object variable. This is not the simplest thing to work with.

I'd give Phil's...

Oh wait! Not all four letter words are bad!

Cold Beer: Two four letter words together and not...

HARD: Another 4 letter word. 😉

I'm in the same time zone and times are showing correctly.

Look at your profile and check what time zone you have selected under forum settings.

Luis Cazares (9/28/2015)

---

Alvin Ramard (9/28/2015)

---

Kristen-173977 (9/28/2015)

---

Alvin Ramard (9/28/2015)

---

Why:

WHERE YourDateColumn >= @StartDate

AND YourDateColumn < @DayAfterEndDate

and not:

WHERE ...