What if you have a table which have multiple combinations of these lookup?

Something like this :

Invoice # : ABC1230092M1

PaymentCode : PaymentCode

DocumentType : Credit Memo

Transported: Home address

If this is happening...

Phil Parkin (7/15/2016)

---

No need for a...

Phil Parkin (7/15/2016)

---

twin.devil (7/15/2016)

---

If you want to do it in SQL SERVER then Tally OH! An Improved SQL 8K “CSV Splitter” Function[/url]

If you want to do in SSIS then check...

If you want to do it in SQL SERVER then Tally OH! An Improved SQL 8K “CSV Splitter” Function[/url]

If you want to do in SSIS then check the following The...

Nice question, Reminded me one of the most asked question by interviewers in earlier days 🙂

Check this T-SQL Bitwise Operations[/url]

Nice question, Thanks for sharing.

+1

btw, Nice question. Thanks for sharing.

Answer would not be acceptable for you,...

you are assuming that you will get two spaces in all rows, which is not true as per the data, you are getting zero in your chart index logic.

i have...

you need to adjust your anchor for recursive CTE to work. something like this:

WITH tmpbom ([itemno], [compno], [quantity], [level])

AS

(

SELECT S1.itemno, S1.compno, CAST(S1.[quantity] AS NUMERIC), 1

FROM...

Have you check your MySQL Settings if then Please check the following link.

pwalter83 (7/4/2016)

---

twin.devil (7/4/2016)

---

If the Scenario is to get the increment load (Insert only mode) then you can use the below.

If your Source data is a SQL SERVER, then you can...

i had repaired a document a few years back. Might help you to understand it. Have some useful links as well.

Please share you Table DDL, along with your sample data, and your desired output for that particular table. It would help a great deal and save everybody time.

you can do...