ERP LABEL DESIGN C SQL QUERY MODIFICATION

Peruttu Julkaistu 4 vuotta sitten Maksettu toimituksen yhteydessä
Peruttu Maksettu toimituksen yhteydessä

HI,

WE ARE USING TURKISH ERP: NEBIM V3

, Query = ISNULL((SELECT UPPER(ProductAtt09) + '.... PSF: ' + UPPER(RetailSalePrice) + ' ... TSF: ' + UPPER(RetailInstallmentSalePrice) + '

'

If you pay attention to the last line here, we made + '(landing on the bottom line)' so that the data is listed one after the other. But it does not happen. When we searched on the internet, they said char (10), 13 or even 9 could be used, and that didn't happen.

The available data comes as follows:

12x45 ... PSF: 5 tl ... TSF: 7 tl ... 50x87 ... PSF: X TL ... TSF: 6 TL ... 4545X4545 ... PSF: 2 TL ... TSF: 4 TRY

AS. THIS

12x45 ... PSF: 5 tl ... TSF: 7 tl

50x87 ... PSF: X TL ... TSF: 6 TL

4545X4545 ... PSF: 2 TL ... TSF: 4 TL

I WANT TO SHAPE IT. IF EVEN IF POSSIBLE,

It would be better to call the size separately, call the ProductAtt09, PSF and TSF separately. ALL THIS DATA COMES WITH THE "Query" AREA IN DESIGN FILE.

SQL C# -ohjelmointi PHP MySQL Oracle

Projektin tunnus: #24489118

Tietoa projektista

11 ehdotusta Etäprojekti Aktiivinen 4 vuotta sitten

11 freelanceria on tarjonnut keskimäärin $26 tähän työhön

achrafchiboub

Hello, I m available. I can start work immediatly Ping me for more details.....................................

$20 USD 7 päivässä
(18 arvostelua)
4.0
znawazch

Very strong in writing SQL & modifications as per need, can understand your problem , can complete this. Will work on SQL part, regarding ERP b/c for that need to understand domain and codings...

$30 USD 1 päivässä
(6 arvostelua)
3.8
designoxyll22

HI, I will design a Label for you which will be Attractive and Tempting.I am Ali from Design Oxyll Expert in Illustrator and Photoshop.I have a Experience of 6 Years in Graphic Designing and I will work work for this p Lisää

$14 USD 1 päivässä
(2 arvostelua)
3.0
SqlDevelopment

Need additional clarification. I did not understand what do you need but i can do anything regarding to SQL. I am Senior SQL Developer with 10+ years experience and i will be glad to share my expertise with you.

$30 USD 1 päivässä
(11 arvostelua)
3.2
aap31374

I  have more then 15 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. I am a Lisää

$55 USD 1 päivässä
(5 arvostelua)
3.2
thegraphics22

Hi, Just read your requirements of "Branding Design",the color and font of the Branding Design will be more attractive and better than your competitor. I am very confident to work on this project becasue I have done Lisää

$20 USD 1 päivässä
(0 arvostelua)
0.0
arsalan7364

Hi I've really good experience in web and database development and I'm interested to do this job kindly contact me so we can discuss this further thank you

$15 USD 1 päivässä
(0 arvostelua)
0.0
patel09dm

Hi there, I have 4 year of experience with SQL programming and able to solve this problem within 1 or 2 hour so if possible please hire me.

$25 USD 1 päivässä
(0 arvostelua)
0.0
Shilpraj

I have good experience with complex queries in SQL server, I will finish this query in short period of time. I have sample query ready using your query, I can send it to you.

$20 USD 1 päivässä
(0 arvostelua)
0.0