Magnificent Terry !

Very very thanks,

Best Regards

SELECT

STL.LOGICALREF,

STL.DATE_ AS TARIH,

--CC.DEFINITION_ AS ADI_SOYADI,

CASE WHEN CHARINDEX(' ', CC.DEFINITION_, 1) > 0 THEN SUBSTRING( CC.DEFINITION_, 1, CHARINDEX(' ', CC.DEFINITION_, 1)-1 ) ELSE CC.DEFINITION_ END...

the first reply was not bad. The first correct answer was yours.

Hmmm, great answer to your schedule is very good.I guess, few can do better.If you have it, this is where the challenge 🙂

Thank you so much, thanks to you, we have the solution.God you get satisfied.

Thank you so much.If your answer is not bad.But 1 person missing.

How many years old is a person born in 09.01.1987?

09.01.1987 de dogan bir kisi kaç yasindadir ?

your result is...

Hi ,

Is it possible to use the results of a Case where filter?

In this topic, you have an additional question to my post earlier.

One prepaid order exists.

Is there a payment plan installment of order 8.

that is, when the order and INVOICE SEPARATELY...

Thank you for your reply, but instead of a textual description of a test or calculation, you can propose a solution how to make equality comparison.Sample query follows.

SELECT ...

Mr. Lynn Pettis, I understand what you said. You have a question. Reduced to the MDF file, your site may I upload? How? Does changing the file extension according to...

I dare say. Field OUTREMCOST somehow got removed from the group by function. Consider these criteria to your query, know what to redesign?

Turned a result of the latest changes you've made. But failed, not the correct result. 6 lines of data would return the query results. But just 64 lines of data...

SQL Server Error :

Server: Msg 8120, Level 16, State 1, Line 1

Column 'LG_086_01_STLINE.STOCKREF' is invalid in the select list because it is not contained in either an aggregate function or...

You're saying, I tried to apply. Unfortunately, I got the following error.

SELECT

SIPFIS.DATE_ AS Tarih,

...

This time I received the following error.

Server: Msg 1033, Level 15, State 1, Line 31

The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP...

Hi , Thank you

but

When I run the query, I get the following error.

Server: Msg 107, Level 16, State 2, Line 1

The column prefix 'STOK' does not match with a...