Search results for query: *

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...

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

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...

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...

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?

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...

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

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...

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...

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...

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...

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...

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...

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...

Thanks for your help Raul

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...

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...

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

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...

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...