Project Detail

Startdate Formated or Deleted  

Startdate Formated or Deleted is project number 438390
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: SoftTouch

Budget: $30-250

Created: 05/21/2009 at 2:48 EDT

Bid Count: 27

Average Bid:
$ 119

06/01/2009 at 2:48 EDT

Project Creator: marandex
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (4 reviews)

Bid On This Project
 

Description

Title: Startdate Formated or Deleted

Overview: SQL Server Database zproducts table inserts a new record into zorders table at the time the order is placed. This works fine. Some of zproducts are BILLING MONTHLY and some BILLING YEARLY. 4 fields are required by Global Gateway (my

secured payment gateway) to have the data of "periodic" "m1" "YYYYMMDDD" "99" in a monthly payment cycle or no data for a yearly billing cycle.

BILLING MONTHLY:
Field: submode Valu "periodic"
Field: periodicity Valu "m1"
Field: startdate Valu "YYYYMMDD"
Field: installments Valu "99"

BILLING YEARLY
Field: submode Valu " "
Field: periodicity Valu " "
Field: startdate Valu " "
Field: installments Valu " "

TWO PROBLEMS TO RESOLVE:
1)Format the datetime to YYYYMMDD Change SQL Server default data type to YYYYMMDD in the startdate field in zorders table (when order is placed)
Important to note that I currently have (getdate()) in the default value...(see images below)

Example: YYYYMMDD = 20090520


2)Create a procedure (or script) to delete the data in zorders.startdate field IF submode = NULL
This result will provide 4 empty fields rather than 4 fields of data.


I welcome you to view the details below so you better understand:
http://www.marandex.com/relationships.jpg
http://www.marandex.com/startdatedesignview.jpg
http://www.marandex.com/zproductsdata.jpg

My Language: Classic ASP VB Script, Database: Microsoft SQL Server 2005 Workgroup Edition


This Project Deadline: June 10, 2009

Messages Posted:2 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

250

5 days

05-22-2009 05:05 EDT

Ready to start

help

 

206

6 days

05-21-2009 03:53 EDT

have a glance at PM. Regards,

help

 

45

1 day

05-21-2009 14:21 EDT

Hi Please check your PMB. Thanks!!...

help

 

100

2 days

05-21-2009 03:01 EDT

hi, Pls. check pMB. Thanks

help

 

200

5 days

05-23-2009 00:39 EDT

Hello, I am a Microsoft certified Professioanl (MCAD .Net, MCTS Sql Server.)and can start with your project as per your requirement. My area of expertise is ASp.NEt, Vb.Net, c#, AJAX, ASP, VBScript, Javascript, Flash, Actionscript,MSSQl,MSAcess,HTML,CSS. We can also provide you online support. Best Regards Shiv Narayan

help

 

30

0 days

05-22-2009 13:43 EDT

I am an IT professional with 10 yrs experience. I have very good experience with ASP, SQL 2000/2005. I will complete this project in few hours.

help

 

175

10 days

05-21-2009 04:52 EDT

Hello, We are ready to start work. We have good knowledge. We can do this according your requirements. We are a professional web development company providing services for Web Design and Web Development in ASP, PHP, OS commerce, .NET and JavaScript. Please provide details and please see PMB for details. Thanks.

help

 

30

1 day

05-21-2009 05:40 EDT

Hi.Kindly send me details via PMB.Thanks

help

 

120

3 days

05-23-2009 08:18 EDT

Hi, we can help you with this. We have 16+ years of programming experience and over 8 in ASP/PHP. Database experts also, bearing years of knowledge and experience in the field. Our price: $ 120 to do this project. Please see PMB for samples of our work. Thanks

help

 

200

5 days

05-21-2009 18:37 EDT

Dear Sir, we are willing to work on this project with you. Looking forward for your feedback. Regards, Bryan.

help

 

120

2 days

05-21-2009 03:35 EDT

quite interesting. see my message and lets continue.

help

 

30

1 day

05-22-2009 06:09 EDT

We do have experience in dealing with dateformat in SQL Server and we are willing to solve your problem in 1 day.

help

 

250

30 days

05-23-2009 05:34 EDT

I am epxerts an have 10 years of exprience in Database and Software Developement and developed amny complex projects. and now ready to work for you. thanks

help

 

30

1 day

05-21-2009 08:08 EDT

Hello, Please see PMB

help

 

70

7 days

05-21-2009 12:24 EDT

Hi, I have 4 years of experience in .NET(C#), SQL Server, Ms Access and Visual Basic. Also I have well knowledge about 3-tier architectures, Web services, XML and XSD. I am working as a senior software engineer in a private concern. I am having experience in N-Tiers and Client/Server architecture application development using ASP.NET/C#/VB.NET/Visual Basic 6.0 as the Front-end, MS-SQL Server 7.0/2000/2005, Oracle 8.0/8i, MS-Access 9X/2000 as the Back-end and experienced in the execution of Technical/Functional Process Design, Implementation activities of small and large projects. Extensive Experience in ActiveX Controls, ActiveX DLLs, ActiveX EXEs, COM, ADO, DAO, ADO.NET, Web Services, .Net Remoting, Web User Controls and using the Object Oriented Techniques while designing the application program development. Possess strong analytical and problem solving skills. I am working on the data migration process. For that I have worked on windows application which will call the external web services and give you the actual result. Also I am working on a product which is based on financial domain. Here we are using 3-tier architecture. Obviously 3-tier architecture depends on the web services. So I am familiar with web services. I am working on the product. I am working on this project for past 3 years. Actually it is based on financial domain. We are using .NET, SQL Server, 3-tier architecture, Web Services, XML and XSD. Prior to this I have done one project called "Unit testing Tool". It is used to testing the developed code. The input of the application is DLL, which you want to test. From this DLL I will list out all the classes using reflection. After that I will list out the methods based on the selection of the class. You can create a test case and execute it. Using this project you can ensure that whether your code is working properly or not. I am really interested to work on this project. Definitely I will deliver the good quality project within the specified time. Please let me know further details, if you are satisfied with me. Thanks in advance.

help

 

200

10 days

05-21-2009 04:23 EDT

Please check My PM.

help

 

100

3 days

05-21-2009 07:42 EDT

I have exp wid same problem. I can solve wid full satisfaction. Thnx n rgrds

help

 

55

1 day

05-22-2009 00:55 EDT

Hi, I have 6 years experience in ASP, ASP.net and SQL server 2000 / 2005. I am ready to work Thanks, Virgil

help

bfn

 

120

2 days

05-21-2009 04:49 EDT

(No Feedback Yet)

Hi, We are a company with specialized in classic asp, PHP, asp.net, c#,vb, sql server, xml, ajax, webservices,Flex and Flash developers. Please check the PMB. Thanks

help

 

150

2 days

05-21-2009 05:28 EDT

(No Feedback Yet)

Please check your PM. Thanks!

help

 

150

15 days

05-21-2009 09:04 EDT

(No Feedback Yet)

We have a S/w companies and working last 10 year on latest technology. We have 150+ client un india . You can seee on my site essentialsoft.co.in also.

help

 

140

2 days

05-21-2009 11:47 EDT

(No Feedback Yet)

Since to me that all the problem is in SQL, I've see and solve this problem before anb will be glad to help you.

help

 

30

0 days

05-21-2009 13:42 EDT

(No Feedback Yet)

Check the answers in the PM

help

 

80

2 days

05-21-2009 14:12 EDT

(No Feedback Yet)

Hi, I have good experience in this field. Developed many projects in ASP/.Net with Mssql/Msaccess database. I have quoted the price for functionality. Let me know if you want to know any further details or list of projects done in past. Look forward to hear from you. Thanks

help

 

130

15 days

05-21-2009 16:30 EDT

(No Feedback Yet)

Please check PMB

help

 

100

3 days

05-22-2009 02:11 EDT

(No Feedback Yet)

We can finish your requirements. We are profession SQL Developers/Administrators. We are doing purely sql developments and troubleshooting.

help

 

100

1 day

05-22-2009 05:44 EDT

(No Feedback Yet)

Vast experience in data conversion, SQLServer 2005 and T-SQL. Can start your task immediately.

help


    Bid on this Project