Archive

Archive for the ‘SQL Server’ Category

Dropdown Displays Available Dates Based On Database Fields

February 22nd, 2012 Comments off

ASP Page, Microsoft SQL Server database

I have a music club SQL Server database with 7 true/false fields in each record indicating whether a club is open each day of the week. For example: Monday – False, Tuesday – False, Wednesday – True, Thursday – False, Friday – True, Saturday – True, Sunday – False.

From this data, I need a dropdown (HTML Select box) displaying the dates the club is open for the next 3 weeks, based on the current date, and in correct order. For example, with the days …

Sql View

February 20th, 2012 Comments off

We have a view in SQL Server Manager – that holds around 35,000 records and is taking around 2 minutes to return all records. Is there a way of re-producing this script to speed up the response time please?

If this is something you can do then please apply for this contract. I have attached the script that creates the view.

Also – is it possible to cache this data until a user updates a record.

Categories: SQL, SQL Server Tags: , , , ,

Web Crawler

February 14th, 2012 Comments off

I need a web crawler that will eventually crawl all web sites in the world and index the home page. There should only be one page per url and then it should go to the next URL. The data must be stored in a SQL Server 2008 database so that it can be searched.

I am not sure where to get the starting point for the web crawler, but I would imagine that there would be many places to get urls that can act as the seeds. If you are bidding on this project, please know where you will get the seed w…

Aspx Sql Server Fb Connectivity Project Changes To Site 2

February 10th, 2012 Comments off

MUST HAVE EXPERIENCE IN
ASPX AJAX SQL SERVER .NET

NEED TO MAKE SOME ADDITIONS TO MY WEBSITE AT WWW.TEXASREALTYPROS.COM

Categories: .NET, Ajax, ASP, ASP.NET, Server, SQL, SQL Server Tags: , , , , , ,

Android Application Wanted 2

February 7th, 2012 Comments off

Hi all,
I need an Android application built for a PDA device. It needs to be built in php/ Sql server.

Please respond.

Convert Sql Server Database To Sqllite

February 6th, 2012 Comments off

I am looking for someone to convert a SQL server database into SQLlite. Would love to hear from anyone who can help me.

Visual Election Data Mapping System

February 4th, 2012 Comments off

PLEASE READ CAREFULLY

Functional Specification
Visual Election Data Mapping System (Vedamaps)

Summary – We are looking for a programmer to recommend an easy to use and manage solution for this.

The overall requirement of the Election Data Mapping System (Vedamaps) is to build a website component that replicate the functionality of the election results map on the BBC for the UK 2010 elections as see here (http://news.bbc.co.uk/1/shared/election2010/results/default.stm).

The com…

Android Application Needed

February 3rd, 2012 Comments off

Hi all,
I need an Android application built to communicate with a PDA device. It is half built in php, xml using a sql server database. The database will communicate with Samsung Galaxy Ace PDA device.

The pages that are needed to be finished are below:
1. Select a job
2. Show job details
3. Job report screen is shown to update
4. Show/ update more details
5. Show/ update customer information
6. Show/ update job status (completed, in progress, not done)
7. Materials screen input (up…

Android Application Wanted

February 2nd, 2012 Comments off

Hi all,
I need an Android application built for a PDA device. It needs to be built in php/ Sql server.

Please respond.

Asp .net / Sql Server App Port To Php / Mysql

January 30th, 2012 Comments off

I have a full ASP .Net invoicing app that needs to be ported to PHP and MySql. I will provide full source code for port. I will provide the URL of the app to review after you PM me. Before bidding, please;

1. Ask for URL to the current ASP .Net app
2. Review the app and provide a rough estimate for port
3. Provide a brief project plan with your bid
4. Provide 3 references directly related to your PHP/MySql work

If you cannot comply with the 3 steps above prior to bid then PLEASE DO NOT …

Mobile Facilities Application For Samsung Galaxy Ace

January 30th, 2012 Comments off

Our current project is a Facilities Management application. The client has desktop users that access our system sitting on their server. Desktop users record phone calls from clients, generate quotes and if these are accepted convert the quote to an order which is a Job. The Jobs are then given Site visits/calls and assigned to one of their engineers. The Engineer is sent the Site visit/call information to his PDA (Samsung Galaxy Ace device). The Engineer will

Small .net Programs For Assignment 3

January 30th, 2012 Comments off

I have up to 8 programs to make. Most of these are applications to manage small business e.g an application to manage a ski resort income. Simple and straightforward.

1. Simple but great interface – Most people who will be using these apps are only familiar with yahoo mail and facebook, at best MS Word.

2. Code has to be simple and well documented so that little modifications can be made. Same for the DB.

3. Easy installation and use. It must be easy to install the app and use it witho…

Aspx Sql Server Fb Connectivity Project Changes To Site

January 24th, 2012 Comments off

MUST HAVE EXPERIENCE IN
ASPX AJAX SQL SERVER .NET

NEED TO MAKE SOME ADDITIONS TO MY WEBSITE AT WWW.TEXASREALTYPROS.COM

Categories: .NET, Ajax, ASP, ASP.NET, Server, SQL, SQL Server Tags: , , , , , ,

Small .net Programs For Assignment 2 2

January 19th, 2012 Comments off

I have up to 8 programs to make. Most of these are applications to manage small business e.g an application to manage a ski resort income. Simple and straightforward.

1. Simple but great interface – Most people who will be using these apps are only familiar with yahoo mail and facebook, at best MS Word.

2. Code has to be simple and well documented so that little modifications can be made. Same for the DB.

3. Easy installation and use. It must be easy to install the app and use it witho…

Qury Ms Database On Win 7 System N Display Inventory On Site

January 13th, 2012 Comments off

Hi, i use a old software “oak street” on my windows 7 system.
http://www.issweb.com/products.html

It stores the inventory in database. It uses Microsoft SQL server compact edition with Visual FoxrPro driver to access the database.

I need someone to create a remote accessible Microsoft server, query the database and display the inventory on my website. So when my clients log in they see the updated inventory. you need to give me the code to embed into my site and it needs to work.

1>…

Support Desk Project

January 10th, 2012 Comments off

Support Desk Project.
1. A web application project to track support desk requests.
2. This project should be done in Visual Studio 2010 – Visual Basic (ASP.net Web Application Project).
3. Backend is SQL Server 2008.
4. Use Telerik controls in the project. We have the license for Telerik.
5. Use CSS.
6. Should use stored procedures.
7. Connection string should store in web.config.
8. The home page should be very attractive.
9. Pages for the menu items, Submit Request, Request Account C…

Android Application On Galaxy Tab

January 4th, 2012 Comments off

We need a very simple application software on Galaxy Tab to be used by Market Research and Survey company. Their surveyors will enter data at several locations simultaneously (more than 25) and synchronize it in a database, preferably SQL Server 2008, on a web server periodically.

Please submit your portfolio of similar projects delivered. After a review of your portfolio we will send you more details of the requirements.

Individuals/companies should preferably be located in New Delhi/N…

Asp.net App + Mobile Apps

December 28th, 2011 Comments off

Hello,

we are company from Slovenia and we are looking for a longtherm relationship developer business partner. For start we have prepared a project for our ecommerce site which we want to be build in .NET (MVC arhitecture) and SQL Server. We already have this solution build in Magento framework + MySQL so we know exactly what we want.

.NET ecommerce web application
Backend:
- Vendor should be able to login into backend (somewhere in frontend) where they can manage their own products, pr…

Need Help With Building Sql Server Query

December 20th, 2011 Comments off

Hello, I need some help with a SQL Server Query in Microsoft SQL Server 2008.

I have two tables, one with device information, and the other with device history. The device history is keyed to the device information id column.

In the devicehistory table I have 4 columns: id, compid, startalarmdate, endalarmdate. I have a script in my application that adds an entry when one of my devices goes into alarm, it puts in the id of the device into the compid column. It also writes the current date…

Move Asp Website To Another Windows Server

December 16th, 2011 Comments off

I have an existing website that I would like to create a clone for on another server. Basically, I need someone with advanced experience in ASP and MS SQL to copy files (including databases) from my existing website to another Windows server 2008. I’m want to create a backup website for testing purpose.

You may visit the existing website by clicking on the below link:

http://goo.gl/XmNe6

Asp.net Website

December 15th, 2011 Comments off

My name is Rajkumar. I have posted a ASP.net platform restaurant website. I have used MS – SQL Server database with this website to show the various recipes available. ASP.net security is also enabled in order to prevent the price being changed from the third-party other than the administrator. Only Administrator has the necessary rights to change the price of the item in the database. A good CSS is done for this website, for the background I have used transparency effects and with other interes…

Categories: .NET, ASP, ASP.NET, CSS, SQL Server Tags: , , , , , ,

Dot Net Developer

December 12th, 2011 Comments off

Designation .Net Developer
Company Spectraforce
Experience 3-5
India
Industry IT / Computers – Software
Job Category IT – Software
Skills .Net, ASP.Net, C#, Sql Server
Location India-Andhra Pradesh-Hyderabad
Website http://www.spectraforce.com

Apply
Click on link or copy paste in your web browser
http://www.jobdhundo.com/viewjob.aspx?id=J20119130357029

Hi,
We are looking for .Net developer for Hyderabad location, please find the details below..

Required Skills:…

Asp Dot Net E-commerce

December 9th, 2011 Comments off

I already have a website in asp.net . It lists the products we have.

I want to add e-commerce feature for the site with cart, qty, discount, shipping price and payment to authorize.net

i use ms sql server 2008 for backend.

*Only send proofs of asp .net e-commerce you have done (3 -5 ) not more than that!!

*Bid lower and within 3 business days i need this.

*I will escrow the funds only on successful demo on your website servers.

*You have to finish the job without bugs/fixes in …

Mysql Upload & Php Page With Search Function Geopostcodes

December 8th, 2011 Comments off

Greetings,
I purchased the geo postal codes for the Philippines from
http://www.geopostcodes.com
it includes the following :

File Encoding File name
Text delimited UTF-8 GeoPC_PH.csv
Microsoft Excel UTF-8 GeoPC_PH.xls
Unformatted ASCII Text ASCII GeoPC_PH.asc
XML structure UTF-8 GeoPC_PH.xml
MySQL database UTF-8 GeoPC_PH.sql
SQL Server 5 UTF-16 GeoPC_PH.dat
General information PDF Product.pdf
License PDF License.pdf
GeoPC_PH.zip 5.55 Mb / 53.22 Mb

This means that the database i…

Sql Server Expert Required

November 28th, 2011 Comments off

To create an automatic job managements process.

Please reply only if you have the following.

Transact SQL very strong
SQL server architecture
Understanding of SQL agent jobs
Understanding of SQL performance
Dba skills.

Pmb for more detailes

Windows 2008 Server Admin For Firewall

November 21st, 2011 Comments off

Looking for honest reliable occasional admin support for Windows 2008 server.

Please quote for cost to check and optimize Firewall settings. Despite having checked settings several times carefully myself, I am being booted off every time I enable the firewall.

I would also like you to create a user account that only has access to a single program and their personal files but nothing else.

Thanks

Database Tuning Of Ms Sql Server Database

November 17th, 2011 Comments off

We need a person to tune the database for the purpose of speed and performance.

Car Dealership Visual Basic.net And Microsoft Sql Server2005

November 16th, 2011 Comments off

Everything is written in file that are attached. This is a very small website project in a collage. I need the master page(homepage) for next monday, and the rest is for other week.The site must be developed using Visual Basic.Net and Microsoft SQL Server 2005. All the detailed info in (PM me for the link).

C# String Parser Routine And T-sql Bulk Upload Script

November 15th, 2011 Comments off

Introduction
—————
I’m in need of two scripts that parse and mine raw data logs into a Microsoft SQL Server.

Scenario
———–
A marketing company has a web service where their customers which are Canadian Universities access on a daily bases. The traffic generated at the web service produces raw logs in the following tabbed delimited format:

Category Name (String)
Entry Point (String)
Traffic Date (Date)
Customer ID (String)
Traffic Count (Integer)
Interface (String…

Sharepoint 2010 Developer Required

November 13th, 2011 Comments off

Key skills are:

.net
SharePoint 2010
SQL Server
Web Part Development
I am looking for a experienced developer.

PMB for more details

Mini Documentation On Sql Standard Commands. 2

November 9th, 2011 Comments off

We need simple mini documentation (english) on 50 sql language features (sql-commands, functions, keywords) for tutorial purpose.

The author should have a good SQL understanding.

This call is for 50 items and each info-item should be between 100 and max 200 words.

We’ll deliver a list of all 50 commands and keywords that we want commented.
We’ll deliver an HTML template to use.
We’ll deliver examples of info-items that will illustrate the quality and depth of explication.

Payment by escrow only.
No payment for error filled articles.
No payment for literal copy of website content. Must pass copyscape 100%.
Must deliver at least 4 items per week

Details:

Each item must have the following sections:
1) Explanation / Comment
3 – 7 lines of comments on how to use this command, function, keyword

2) Version / Platform
Is this command special to Oracle 9, SQL Server 2005 or MySql etc.

3) Conscious Example
A short and typical example which ilustrates the usage of this command, function, keyword
If possbile with a result.

Seeking Part Time Microsoft Server Admin

November 7th, 2011 Comments off

We are HomesUSA.com, a small but fast-growing company based in Dallas, Texas, USA. We are seeking to hire a part-time Administrator for our servers for a permanent position. You may live and work from anywhere in the world. You will work 100% via a virtual work environment supported primarily by e-mail, Skype, FTP/SSH, and Windows Remote Desktop.

We are in the process of acquiring new Windows based servers and seek an Administrator to migrate all data and systems from present servers to new servers in a timely manner. (See attached file for a list of current and new servers.)

TO APPLY FOR THIS POSITION: Please provide (1) an estimate for the initial migration, (2) your hourly rate for administration, and (3) a list of your references.

Requirements:
* Bachelor’s degree in related field or combination of education and experience required.
* Must be able to communicate in English with personnel at all levels and work closely with software developers
* Proficient in:
– Server administration and management of Microsoft Windows system 2003 and 2008
-ISA 2006, TMG 2010, IIS, MS Exchange 2010
– Microsoft SQL Server 2008
– Hyper-V Experience is a plus
* Work from your location in any country, will need to have your own computer and internet access

Ongoing duties will include the following:
* System monitoring, preventive maintenance and prevention of unauthorized intrusions
* Update and maintain server installation and configuration procedures and documentation
* Investigate and troubleshoot server issues; review server event logs
* Implement, test and document disaster recovery procedures
* Automate tasks where possible (backups, maintenance)
* Configure services, settings, storage, directories, groups and membership
* Conduct performance tuning, hardware upgrades, and resource optimization
* Configure CPU, RAM, and disk partitioning as required
* Assist in hardening servers per best practices
* Ensure security patches are current
* Assist in installation and configuration of software on workstations.

Classic Asp3.0 Project Maintenance

November 5th, 2011 Comments off

Need to find a good individual or a company with a very quick response time to work on a small maintenance updates on a Classic ASP3.0 ecommerce site. It is an ecommerce site with a custom CMS backend, and SQL Server DB. Please provide the rate that you will work by for these projects.

Also show me your classic ASP site you worked on with a proof that you did it.

Convert A File From A Sql Server 2005 To Csv

October 31st, 2011 Comments off

We have a backup .BAK file from a SQL Server 2005. (+/- 7 MB)

The file has about 45 tables. We need every table in a separate .CSV doc.

Mini Documentation On Sql Standard Commands.

October 27th, 2011 Comments off

We need simple mini documentation (english) on 50 sql language features (sql-commands, functions, keywords) for tutorial purpose.

The author should have a good SQL understanding.

This call is for 50 items and each info-item should be between 100 and max 200 words.

We’ll deliver a list of all 50 commands and keywords that we want commented.
We’ll deliver an HTML template to use.
We’ll deliver examples of info-items that will illustrate the quality and depth of explication.

Payment by escrow only.
No payment for error filled articles.
No payment for literal copy of website content. Must pass copyscape 100%.
Must deliver at least 4 items per week

Details:

Each item must have the following sections:
1) Explanation / Comment
3 – 7 lines of comments on how to use this command, function, keyword

2) Version / Platform
Is this command special to Oracle 9, SQL Server 2005 or MySql etc.

3) Conscious Example
A short and typical example which ilustrates the usage of this command, function, keyword
If possbile with a result.

Rostering And Scheduling Project

October 25th, 2011 Comments off

Hi,

i’m interested to purchase and make some customisation to a rostering and scheduling system with codes to be developed in ASP.NET with DB – SQL Server 2008.

The system is to be developed for a retail industry with more than 50 possible concurrent users usage scheduling more than 400 part-timers at work. Some simple scenario includes determining work schedule based on address, rescheduling employee next day roster plan when an employee falls sick, adhoc change of schedule of certain personnel (affecting those involved only – sending out SMS if possible), change of working time of employees rescheduling etc.

Please show me some sample of similar project for my decision making. Be realistic about your development timeline since you have a ready solution to customised and i’m open to suggestion along the way to better the solution concept.

Thanks.

Sql Server/asp.net Reporting/sales Analysis Site

October 18th, 2011 Comments off

We have been using a previous company, but they have been unable to complete some of our requests and I need these updates done today.

We have a site that we import data to from our shopping cart provider via CSV files. There are also 2 tables that update daily via FTP.

We need to make some reports exportable to CSV files, a few reports addeded and many of the reports “Cleaned up” to run faster.

We need someone VERY good at SQL and generating detailed reports, maybe even coming up with some reports we haven’t thought of. You also need to know ASP.NET since that is the front end.

Once you respond to this project I will give you a login to our site so that you can give me an accurate cost and to make sure you can do the job.

Software Or Website Developer In Php – 3 Yrs Experience Min.

October 14th, 2011 Comments off

Job Description
+ experienced in Windows/Web applications development using
PHP, Asp & Asp.net, VB.Net, C# ,web services, web parts, online shopping , payment gateway information, awareness for market technology etc.
+ SQL Server 2000
+ Sound technical knowledge

Academic Site With Video And Membership On Sql Server

October 9th, 2011 Comments off

Website Requirements:
- Webpage is going to be used for students to login into, and view course enrolled in, the assignments posted by instructor, comments by instructor (both to class in general or to student individually), videos posted by instructor.
- It is going to need to run on a SQL server.
- It must create manageable tables which can be viewed with mySQL etc

Some Fixes And Hosting Problem Resolutions For 3 Sites

October 5th, 2011 Comments off

We need to de-bug three sites for small errors in functions for our clients. Sites are fully functional and have little issues only (not more than 5 per site). Sites are online stores and made in PHP, hosted on linux hosting package at godaddy.com.
We need providers who have experience in PHP and godaddy working too.

We also need one of the above mentioned sites shifted from one to another hosting plan with same provider i.e., godaddy. That will require complete backup of site and database first, cancelling of account, making new hosting plan (that we will make), and uploading and restoring full functionality of the site.

This is a trial project for those who intend to start a good working relationship with our company on long term basis. Budget for this tiny task is minimal but you can expect earn good value from other projects if we like the way you work and quality you produce.

Site names and bugs reports will be shared in PM with shortlisted candidates only.

Bear