Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sardinka2

    temp table

    can you help me write one. basically I need to know when job was last time was executed, with fail or susecc, and next run time.
  2. sardinka2

    temp table

    I am trying to create a temp table. What am I doing wrong? insert into #job exec msdb..sp_help_job @job_name='.dba.archive.baks',@job_aspect ='steps'
  3. sardinka2

    Job

    can I select a spesific fields?
  4. sardinka2

    Job

    it is some how I can find out programatically job name,schedule time, sucess/fail?
  5. sardinka2

    where clause

    I have the following where clause...Right now it is slow.It is anyway I can speed up by rewriting differently?? and ( b.ID1 = a.ID1 or b.ID2=a.ID2 or (Replicate ('0',11-len(b.ID3)) + b.ID3)=a.ID3) AND ( a.ID1 = @ID or (Replicate ('0',11-len(a.ID3)) + a.ID3)=@ID or a.ID2=@ID)
  6. sardinka2

    Insert query

    What is wrong with my query?It will not compile insert into table1 (GID, SID, DateEntered) values ( select GID,SID,getdate() from table2 where GID='1' and SID not in (select SID from table3 where GID='1') )
  7. sardinka2

    BCP

    Does anyone know a good site with examples of bcp dts workflow and error handl?
  8. sardinka2

    Trigger

    I mean exec trigger when spesific column updated (for example colum 2). Thanks
  9. sardinka2

    Trigger

    Thans it helps. Can I run a triger when spesific column was updated?
  10. sardinka2

    Trigger

    I am trying to create a triger for insert. I would like to get id into log table id data was inserted.What am I doing incorrect: if exists (select * from dbo.sysobjects where id = object_id('dbo.mstr_update') and OBJECTPROPERTY(id, 'IsTrigger') = 1) drop trigger dbo.mstr_update GO CREATE...
  11. sardinka2

    ActiveX

    Is it posible to create a file using a activex script as well as exec sp in activex and save the data into file created by activex? can some one show me the examples?
  12. sardinka2

    Mail

    Here is my code for CDOMail. However when I try to send to attachemnt it will not work (working with one attachment only). Any idea why? CREATE PROCEDURE CDO_SendMail( @From varchar(255) = 'sql@msn.com', @To varchar(255), @Cc varchar(255) = '', @Bcc varchar(255) = '', @Subject...
  13. sardinka2

    variable

    I have a param @MessageBody varchar(8000). I am assigning some values to the select @MessageBody=select.... It working fine until I the results is only 1 row, however when it is more then one it is taking only top 1 row. What should I do in order to get all rows?
  14. sardinka2

    DateTime

    I have the following datetime. 2004-04-21 16:24:36.790 I would like to display as: 20040421162436 How do I do this?
  15. sardinka2

    Copy File

    The problem is user is removing the files and they don't exits in a directory I am trying to copy also the file name will be different everytime .
  16. sardinka2

    Copy File

    I am trying to copy an .xls file. However when I am using a fso.CopyFile FName, DstFName I need to know the file destination. But in my case I would like to copy a file from one place to other where desctination file is not exists. How do I do this?
  17. sardinka2

    Subquery

    I have 7 answers with possible combinations 'Yes' and 'No'. Maybe temp tamp will work? In a temp i will need to have the data store like this: Answer TranID Y Y Y .. 123 can you help me write this?
  18. sardinka2

    Subquery

    Not really. I need to display all Yes and No. Not just a sum
  19. sardinka2

    Subquery

    I have the following code where I have some subquery. However my subquery return more than 1 row. Is it some how I can put all subquery result in 1 row instead of couple? select Custom1=(select case Answer when 'Yes' then 'Y' else 'N' end + ' ' fromAnswers wa where wa.tranid=wt.TranID )...
  20. sardinka2

    Process task

    Where should I check the permissions?

Part and Inventory Search

Back
Top