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 Chriss Miller 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: *

  • Users: sereleg
  • Order by date
  1. sereleg

    Read binary from database

    I used the following code to insert a file as binary into a SQL server database. id FileType filelength description FileData 1 application/msword 31232 bus.doc <Binary> private void Button1_Click(object sender, System.EventArgs e) { SqlConnection conn=new...
  2. sereleg

    ADDING DATES

    Thank you for your help vongrunt, your solution was exactly what I was looking for. Thanks so much
  3. sereleg

    ADDING DATES

    First, I will need to convert those three [day (nvarchar), month(nvarchar),yeaR(nvarchar)] fields as a regular Date format so I can used in my comparition. Second I'll need to compare the dates from one actionid with the next(There are 6 actionID). EXAMPLE: If I want to get how long it takes...
  4. sereleg

    ADDING DATES

    I will appreciate any help with the following: ID------PNO---ACTIONID--DAY----MONTH----YEAR 144 756 1 26 4 2005 145 756 2 27 4 2005 146 756 3 29 4 2005 147 756 4 30 4...
  5. sereleg

    I need to display binary data from SQL SERVER to the browser

    Obislavu 1.-Do you think it should be better to store that binary files directly to the hard disk INSTEAD TO THE database? 2.-There is a way to get the data displayed directly from DATABASE to the browser?
  6. sereleg

    I need to display binary data from SQL SERVER to the browser

    I need help to display binary(could be pdf,doc,txt,etc) data stored in SQL server to the browser. table=FileData id int FileType varchar FileLength int description varchar FileData image I described the sql server table so you can have an idea of the...
  7. sereleg

    LDF FILES ARE EXTREMELLY HIGH

    I have a sql server 2000 database with its LDF file incresing day by day. Could some one help me to solve this situation the size is almost 10GB and the server is almost full. Thanks
  8. sereleg

    FUNCTION TO CONVERT FIELDS TO MONTHS !!

    I will appreciate any help to calculate the fields below into month: Example: For productID =1019 How many month are from 20/4/2005 to 26/05/2005 the result in this case could be 1 and 6 days approximadamente or 1.2 moth PID FDAY FMONTH FYEAR TDAY TMONTH TYEAR 1019 20 4...
  9. sereleg

    ADDING DATES

    After executing the next query I obtain the data bellow.. Query: SELECT datechanged,id,posid,upby,day,month,year,seto FROM tblPostingStatusTrail a WHERE a.seto = 'on' datechanged--id---posgid--upby----day-month-year-seto 2003-03-17 1 500 Gerar 4 1 2005 on 2005-04-11 55 475...
  10. sereleg

    How to sincronize two table (Stor procedure,Triggers)

    Thank you for your response The query I provided is just a sample to visualize the fields I need to automate. The reality is that fields should be inserted in "EmploymentExp" automaticly every time a new record is inserted on "Employment" table. Employment table is related to Candidates table...
  11. sereleg

    How to sincronize two table (Stor procedure,Triggers)

    Dear Danny Thanks for your response I would like you help me to fire a trigger for insert base on the conditions I described below. For the update case I need to have clear other situations that I have not taking into account yet. QUERY A: SELECT...
  12. sereleg

    How to sincronize two table (Stor procedure,Triggers)

    I really need some ideas to acomplish this task.. I need to Insert the data obtained by this QUERYA to a table called EmploymentExp which have the same fields as the query with an ADDITIONAL ID field which is incremented by one everytime a new record is inserted. QUERYA: SELECT...
  13. sereleg

    Unable to connect to Internet with w 2003 server

    Hello everyone I have Windows 2003 server and XP professional installed on my PC. I used to connect to internet with both operating system with out any problem but after I did a a windows update on Windows 2003 server the connection to the internet for that Windows 2003 server went down. I...
  14. sereleg

    Change Connection to Database

    Hi all I have an Excell document that brings data from SQL server using an Store procedure. This Excell document is reading an old database so I need to update the data source by changing the old database name with a new one. I would like to create a new EXCELL but this is a very sofisticated...
  15. sereleg

    IP locator

    Thanks for your help Raul
  16. sereleg

    IP locator

    I need some info about how to detect client IP address' geographical location and display website content base on this information. Did some one can suggest a software or steps to follow to accomplish this task, I have .NET framework running on Windows 2003 operating system. I will appreciate...
  17. sereleg

    IP LOCATOR AND DATABASE

    I need some info about how to detect client IP address' geographical location and display website content base on this information. Did some one can suggest a software or steps to follow to accomplish this task, I have .NET framework running on Windows 2003 operating system. I will appreciate...
  18. sereleg

    Filter by numeric in select

    Thanks For your help, I accomplished what I was looking for. Thank you so much Raul
  19. sereleg

    FILTER BASE ON DATE

    I need some help to filter a record set using the greatest year: My sql select EMPLID,Action_DT from PROFILES.dbo.ps_job where Action in ('PRO','XPR') AND EMPLID in ('062497','105149') ORDER by EMPLID des I just place two EMPLID but could be thousands of them. EXAMPLE EMPLID date 105149...
  20. sereleg

    Case Statement Select

    I need some help to filter a record set using the greatest year: My sql select EMPLID,Action_DT from PROFILES.dbo.ps_job where Action in ('PRO','XPR') AND EMPLID in ('062497','105149') ORDER by EMPLID des I just place two EMPLID but could be thousands of them. EXAMPLE EMPLID date 105149...

Part and Inventory Search

Back
Top