October 18, 2016 at 1:32 am
Hello all,
okay i have an issue and i am going to seek the help of some experts here...
basically i created a formula... something like this spj(16909)(a/3)+spj(16212)(a/3/3)+spj(16214)(a/3/3)+spj(16918)(a/3/3)+spj(16472)(a/3/3)+spj(16473)(a/3/3)+spj(16779)(a/3/3)
Problem is the "IDs" such as "16909" etc are actually pulling the wrong IDs.
Can someone give me a way of finding the old IDs which exist in the formula and update them with the new ones.
i have more than 300 formulas and it is too long to manually update these.
Please help.
October 18, 2016 at 3:44 am
Any chance of a bit more info?
Please see the links in my sig line for more info.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
October 18, 2016 at 4:04 am
thanks for the response.
okay so as explained above the formula currently reads like this
spj(16909)(a/3)+spj(16212)(a/3/3)+spj(16214)(a/3/3)+spj(16918)(a/3/3)+spj(16472)(a/3/3)+spj(16473)(a/3/3)+spj(16779)(a/3/3)
as you can see it contains a specific number after the bracket but this number is actually incorrect and needs to be this:
spj(17931)(a/3)+spj(17234)(a/3/3)+spj(17236)(a/3/3)+spj(17940)(a/3/3)+spj(17494)(a/3/3)+spj(17495)(a/3/3)+spj(17801)(a/3/3)
the number in the bracket is now the correct one, however i did this manually and i have a whole bunch of Formulas to do and this will be time consuming, therefore i need any help to find and replace the numbers in the brackets.
October 18, 2016 at 4:11 am
What is that from? spj is not a T-SQL function, so not SQL Server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2016 at 4:15 am
spj basically means "Sub-project"
October 18, 2016 at 4:33 am
What language is that?
Where do you get the numbers that need to be replaced and the numbers that replace them?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2016 at 7:00 pm
compufreak (10/18/2016)
Hello all,okay i have an issue and i am going to seek the help of some experts here...
basically i created a formula... something like this
spj(16909)(a/3)+spj(16212)(a/3/3)+spj(16214)(a/3/3)+spj(16918)(a/3/3)+spj(16472)(a/3/3)+spj(16473)(a/3/3)+spj(16779)(a/3/3)Problem is the "IDs" such as "16909" etc are actually pulling the wrong IDs.
Can someone give me a way of finding the old IDs which exist in the formula and update them with the new ones.
i have more than 300 formulas and it is too long to manually update these.
Please help.
Are you saying that these formulas are stored in a table in SQL Server?
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply