http://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/3581.aspxWed, 12 Dec 2007 15:20:52 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:3581B_gd_n[ ]Sahlean0http://sqlserver.ro/forums/thread/3581.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=3581<p><a href="http://sqlserver.ro/forums/permalink/3495/3497/ShowThread.aspx#3497" target="_blank">http://sqlserver.ro/forums/permalink/3495/3497/ShowThread.aspx#3497</a></p><p>Mod de apel functie (suma este 1):</p><p><span style="font-size:10pt;font-family:'Courier New';color:blue;">SELECT</span><span style="font-size:10pt;font-family:'Courier New';"> dbo<span style="color:gray;">.</span>Conversie_Valutara<span style="color:gray;">(</span><span style="color:red;">'2007-01-05'</span><span style="color:gray;">,</span><span style="color:red;">'USD'</span><span style="color:gray;">,</span>1<span style="color:gray;">)</span> <span style="color:blue;">AS</span> Suma</span> <br></p>http://sqlserver.ro/forums/thread/3580.aspxWed, 12 Dec 2007 14:01:03 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:3580Diana0http://sqlserver.ro/forums/thread/3580.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=3580Poti sa dai mai multe detalii despre felul in care faci importul?<br>http://sqlserver.ro/forums/thread/3579.aspxWed, 12 Dec 2007 13:36:04 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:3579Scorpio0http://sqlserver.ro/forums/thread/3579.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=3579<p>Salut,</p><p>Am si eu o mica problema, imi trebuie o tabela in care sa am cursul bnr pt fiecare zi. Importul in sine nu ar fi o problema.</p><p>Eu am nevoie de curs inclusiv sambata si duminica asa ca mi-ar trebuii o functie care atunci cand preiau cursul dintr-o tabela pentru o anumita data sa-mi intoarca cursul anterior daca pt acea data nu gaseste inregistrare si asa mai departe pana gaseste o inregistrare</p><p>Ex: daca am nevoie de cursul valutar pt fiecare zi dintr-o saptamana, iar in ult 3 zile nu a fost introdus(vineri,sambata,duminica), sa-mi afiseze pt acele 3 zile cursul valutar de joi.</p><p>&nbsp;</p><p>Sper sa ma poata ajuta cineva....<img src="http://sqlserver.ro/emoticons/emotion-6.gif" alt="Sad" />&nbsp;</p>