Once you have executed these commands, the error log starts filling up, so you may want to keep an eye on it from time to time and turn it off...

not sure what you mean.

I made the user fix the data, and warned them about being more careful with their data entry.

HI,

 count(INVOICE.SB_INVOICE_ID ),

 count(distinct INVOICE.SB_INVOICE_ID )

return 57 and 15 records respectively.

The Invoice table sb_invoice is the child of sb_invoice_print, therefore 1 sb_invoice_print may be the parent of many sb_invoice records.

figured it out in the end.

DECLARE PATIENT_CURSOR CURSOR STATIC READ_ONLY FOR

Usually id use DTS, but I was not sure how to proceed to insert into SB_DEBTOR first, and use...

Thanks, the problem is sorted now!

my brain engaged finally:

RIGHT(

LEFT(SB_CHART_OF_ACC_CODE, CHARINDEX(',',SB_CHART_OF_ACC_CODE, CHARINDEX(',',SB_CHART_OF_ACC_CODE)+1)-1)

 ,

CHARINDEX(',',SB_CHART_OF_ACC_CODE, CHARINDEX(',',SB_CHART_OF_ACC_CODE)+1)

-

CHARINDEX(',',SB_CHART_OF_ACC_CODE)

-1

)

Hi,

The third param of substring is LENGTH.

I don't know the length of my 666 string, is usually 3 characters, but could be 4 or 5.

I should have mentioned that.

are you able to give the other three columns names?

col1, col2, col3 so you can refer to them in code?

Hi,

Actually, the answer is Delimited, with row delimiter crlf, and a column delimeter of (I started typing "{" .. the rows populated) so I left the delimiter as "{"

Hi,

Id forgotten about TRUNCATE. I don't give it much use. ;-0

Thanks guys

thanks guys,

figured it out: row delemiter = crlf

thanks for all your help.

Hi,

I had it working earlier, but for the life of me, I can't get it to work again. I lost the package when my computer crashed.

I set the type to...

Hi,

I tried what you suggested, but it seems that the carriage return and line feed is being counted as part of the ling length if you nkow what I mean

Say...

is it just me, or is the article really center aligned? It makes it hard to read I think.

Hi,

Why don't you use:

WHERE

(@Op = 1 AND COL1 = @ParamValue)

OR

(@Op = 2 AND COL2 = @ParamValue)