Welcome to Sign in | Help
» Search

Search

You searched for the word(s):
Showing page 25 of 39 (389 total posts) < 1 second(s)
  • Re: script de SELECT cu GROUP BY sql server 2000

    nu mai e nici o suparare....scuze ca am raspuns asa tarziu dar abia acum am reusit sa scap de ''probleme'' :) ''problema'' pleaca de la faptul ca am importat in baza de date mai multe ori aceleasi date (CompanyName)....cheia pe tabela respectiva fiind pe LeadID (ceea ce ma face sa ma gandesc daca ar trebui si CompanyName sa-l fac unic ...
    Posted to T-SQL (Forum) by Alex on July 6, 2007
  • Re: script de SELECT cu GROUP BY sql server 2000

    nu e bun nici al meu nici al tau....ii lipseste ceva....inca imi mai intoarce greseli....leadID pentru alt Companyname....nu inteleg cum poate :( &nbsp;
    Posted to T-SQL (Forum) by Alex on July 6, 2007
  • Re: script de SELECT cu GROUP BY sql server 2000

    am facut asa pana la urma select distinct A.LeadID,A.CompanyName from LeadBase Ajoin&nbsp; LeadBase B on A.CompanyName = B.CompanyName and A.LeadID &lt;&gt; B.LeadID and A.statecode = 0&nbsp; and A.deletionstatecode = 0 and B.statecode = 0 and B.deletionstatecode = 0where A.Companyname is not nullorder by A.CompanyName asc sunt sigur ca exista ...
    Posted to T-SQL (Forum) by Alex on July 6, 2007
  • Re: script de SELECT cu GROUP BY sql server 2000

    cred ca ceva de genul ....dar nu sunt sigur select distinct A.LeadID,A.CompanyName from LeadBase Ajoin&nbsp; LeadBase B on A.CompanyName = B.CompanyName and A.LeadID &lt;&gt; B.LeadIDwhere A.statecode = 0 and A.Companyname is not nullorder by A.CompanyName asc
    Posted to T-SQL (Forum) by Alex on July 6, 2007
  • script de SELECT cu GROUP BY sql server 2000

    salut...am si eu o problema cat se poate de urgenta cu selectul asta :( select companyname,cnt,x.LeadId from (select count(companyname) cnt, companyname,LeadId from (select * from LeadBase where statecode = 0)y group by companyname)xwhere x.cnt &gt; 1 el acum afiseaza eroarea: Server: Msg 8120, Level 16, State 1, Line 1Column 'y.LeadId' is ...
    Posted to T-SQL (Forum) by Alex on July 6, 2007
  • Re: eroare job legat de Microsoft CRM (SQL Server 2000)

    multumesc mult...asa o sa fac ;) alex.
    Posted to Intrebari generale (Forum) by Alex on July 3, 2007
  • eroare job legat de Microsoft CRM (SQL Server 2000)

    salut, am si eu o problema cu un job care se executa zilnic la 15 minute intr-un interval de 8 ore....acest job executa exec sp_fulltext_catalog N'ftcat_documentindex', N'start_incremental' nu stiu cine si de ce se executa acest sp_fulltext_catalog......este legat de Microsoft CRM....care foloseste in spate SQL Server 2000 si care la instalare ...
    Posted to Intrebari generale (Forum) by Alex on July 3, 2007
  • restore history....pot afla?

    salut......cum pot afla data la care au fost facute restoruri pe o baza de date in sql server 2000.....se salveaza datele acestor restoruri multumesc mult. &nbsp; alex.
    Posted to Intrebari generale (Forum) by Alex on July 3, 2007
  • Re: trigger de INSERT,UPDATE - SQL Server 2000

    si la mine ''replicarea'' e cam zero.....inafara de putina teorie altceva nu mai stiu legat de asta......dar poate e momentul sa invat :)....o sa ma gandesc si la varianta asta......bine macar ca o varianta, chiar si asa ''facuta pe genunchi'', functioneaza si nu-mi sta in carca...:) multumesc. alex.
    Posted to T-SQL (Forum) by Alex on June 26, 2007
  • Re: trigger de INSERT,UPDATE - SQL Server 2000

    ce mai vorbesc singur pe aici :)))))))))))).....dar tot e bine ca se rezolva lucrurile :) alex.&nbsp; &nbsp; Edit...am gasit varianta cea mai simpla.... ca de obicei varianta cea mai buna si simpla o ''vad'' ultima :) CREATE TRIGGER [trg_Equival_INSERT_UPDATE] ON [dbo].[EQUIVAL]FOR INSERT,UPDATEASif ((select ...
    Posted to T-SQL (Forum) by Alex on June 25, 2007
« First ... < Previous 23 24 25 26 27 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems