|
Search
You searched for the word(s):
Showing page 1 of 2 (11 total posts)
< 1 second(s)
-
Doresc si eu sa particip. Multumesc de invitatie!
-
-
selectul e urmatorul:
SELECT func_qjn22_Grp_PfVkn_SOLL.VknID, func_qjn22_Grp_PfVkn_SOLL.TypNr, func_qjn22_Grp_PfVkn_SOLL.GenNr, func_qjn22_Grp_PfVkn_SOLL.Folge, func_qjn22_Grp_PfVkn_SOLL.ArtNr, func_qjn22_Grp_PfVkn_SOLL.AnzKrit AS PfSoll, (CASE WHEN PfSoll > func_qjn22_Grp_PfVkn_SOLL.AnzKrit THEN func_qjn22_Grp_PfVkn_SOLL.AnzKrit ELSE ...
-
-
stie cineva cumva cum schimb urmatoarea expresie
''FORMAT([vknKrit_Pkw].[kritnr],'0000')'' din access in sql server???
stiu ca ar trebui sa folosesc functia CONVERT dar nu stiu cum???
multumesc anticipat!!!
-
-
imi da urmatoarea eroare:
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified....
deci nu pot pune order by in subquery?
merci...
-
si ce se intampla daca cele doua tabele din join au coloane cu acelasi nume?
-
urmatorul select da eraore pt ca nu am campurile din order by in select distinct....
fara distinct rezultatul e cu duplicate...
SELECT DISTINCT A.x, A.y, A.z, B.m, B.n, B.qFROM (B INNER JOIN A ON B.w=A.w)WHERE A.x = '1'ORDER BY B.f, B.g, B.h
cum pot elimina duplicatele si la order by sa am alte campuri decat in ...
-
urmatorul DELETE e facut in Access si se sterg campuri din doua talele...
cum fac asta in sqlServer?...
DELETE DISTINCTROW ArtStk.ArtNr, ArtStk_Land.* FROM ArtStk INNER JOIN ArtStk_Land ON ArtStk.StkID = ArtStk_Land.StkID WHERE ArtStk.ArtNr = 0
Multumesc anticipat?
1
|
|
|