Recent content by MrsMope987

Here is a query that I use to access this function: SELECT G.yr, G.GLDivNo, G.GLDeptNo, G.GLAcctNo, G.GLSubNo, G.GLTitle, F.Mnth, F.Val FROM PROGRESS..PUB.GLSA G CROSS APPLY dbo.ParseValues(G.peramt,';')F WHERE G.Cono=1 AND G.yr=9 I want another column in the temp table called Mnth...

yes, but does the ID column reset each time a new @string is looked at? That's what I need for each @ string that's looped through I need the Month field to reset and begin at 1 again until that field is delimited, then reset to 1 again for the next field.

Hello, I have a field that has 13 values in it separated by a semi-colon. Each value = a month, the 13th is for year-end adjustments. The table housing this field is stored in a PROGRESS database, I'm using the following SQL function to split these values into unique rows. I have SQL 2005...

This isn't stored in a SQL Server, it's in a progress database. So I'm trying to pull it out of the progress database and put it into a SQL database in the correct format (one column for each value). I don't know WHY the progress one is set up that way, but there are a lot of tables like that...

PeriodAmt is a column in the referenced table and I'm assuming by reading the code listed in the FAQ I copied this piece from that the S.Value is the identifier that matches the G.RowID.

Error Message (a different one though) Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "G.PeriodAmt" could not be bound.

I made the changes you suggested, but I still get the same error.

Hello, I've read the FAQ on this site for the Split function, I want to take a field that has 13 different values delimited by a semi-colon. These values are for each month and one for adjustments. I need to have this split out as such: Field Currently: RowID Title 3 MANAGEMENT...

Anybody got any suggestions for me? I still can't get this working.

I still haven't got this working, anyone with a suggestion?

Yes I did run the create statment and I can see the function in my object explorer. If I run the following SELECT * FROM splitWords('9;8;7;8;9;7;8;8;99;9;8;7') I get records returning as they should but when I use SELECT G.CoNo, G.GLDivNo, master.dbo.SplitWords(G.peramt) as 'Something' FROM...

Thanks, that website did have the function that I needed. But I still don't know how to get the results returned. I assumed it would be simple like: SELECT G.CoNo, G.GLDivNo, SplitWords(G.peramt) as 'Something' FROM PROGRESS..PUB.GLSA as G But when I check the syntax I get an error Msg 195...

Dumb question but... once I create this function, how do I reference it from my query to get the result set back split?

Does the PARSENAME have a limit of 4 fields though? I have 13 I need to split out (each month and one for end of the year adjustments).

I'll try it. thanks