Käynnissä

Startdate Formated or Deleted

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 [url removed, login to view] 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:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

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

This Project Deadline: June 10, 2009

Taidot: .NET, ASP, tietojenkäsittely, Visual Basic, Windows Desktop

Näytä lisää: global payment gateway, c language overview, billing microsoft, startdate, create excel template import data, periodic, null, m1, change deadline, table jpg, yearly, resolve server, classic asp required field, sql view table, deleted project, change welcome, datetime, microsoft sql server 2005, pending order deleted, visual basic sql server example, database procedure, classic asp procedure, sql asp classic, create jpg script, periodic payment

About the Employer:
( 31 reviews ) Antioch, United States

Projektin tunnus: #438390

Myönnetty käyttäjälle:

SoftTouch

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

30 $ USD 1 päivässä
(4 arvostelua)
3.2

27 freelanceria on tarjonnut keskimäärin 119 $ tähän työhön

yousefla

Ready to start

250 $ USD 5 päivässä
(80 arvostelua)
7.3
Nirmal2006

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

45 $ USD 1 päivässä
(151 arvostelua)
7.1
ITservice

hi, Pls. check pMB. Thanks

100 $ USD 2 päivässä
(106 arvostelua)
7.1
shmai

have a glance at PM. Regards,

206 $ USD 6 päivässä
(184 arvostelua)
7.0
shivnarayan

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, F Lisää

200 $ USD 5 päivässä
(27 arvostelua)
6.6
exoticsolutions

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

200 $ USD 5 päivässä
(16 arvostelua)
5.9
nmppatel

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.

30 $ USD 0 päivässä
(39 arvostelua)
5.2
MajidAliQureshi

[url removed, login to view] send me details via [url removed, login to view]

30 $ USD 1 päivässä
(11 arvostelua)
5.0
dsendra

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. Plea Lisää

120 $ USD 3 päivässä
(19 arvostelua)
4.9
Gm2009Software

quite interesting. see my message and lets continue.

120 $ USD 2 päivässä
(4 arvostelua)
4.1
code09

Hello, Please see PMB

30 $ USD 1 päivässä
(11 arvostelua)
3.7
suraArumugam

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 Lisää

70 $ USD 7 päivässä
(3 arvostelua)
3.1
dhirenkashyap

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 Lisää

175 $ USD 10 päivässä
(1 arvostelu)
2.7
ProExpert

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

250 $ USD 30 päivässä
(4 arvostelua)
2.4
virgilraj

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

55 $ USD 1 päivässä
(1 arvostelu)
2.0
rhussain

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

100 $ USD 3 päivässä
(2 arvostelua)
1.6
mrcool18t

Please check My PM.

200 $ USD 10 päivässä
(0 arvostelua)
1.0
bfn

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

120 $ USD 2 päivässä
(0 arvostelua)
0.0
sltang

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

100 $ USD 1 päivässä
(0 arvostelua)
0.0
Dragonism

Please check your PM. Thanks!

150 $ USD 2 päivässä
(0 arvostelua)
0.0