Tsqltrabajos
Long range forecasts are based on characteristics. In the long range time horizon the specific characteristic combintaitions that receives a forecast are an indicator of what UPI(unified planning item) and finished good items will eventually be made and sold. A forecast object will be created based on the LRP item type and the characteristics associated to a forecastparameter such as wafer starts or test outs. The characteristics will align with the icost characteristics used to create cost and reserve material groupings. This includes creating new forcast objects based upon data received in the LRP forecast Population of the froecst parameters which are associated to an LRP item and included in the LRP extract. Population of a forecast BOM -Die to tested unit. Load LRP...
We are looking for someone with skills in TSQL and XQuery to write a procedure that will find and display (in a table) a search string which can have different input options. For demonstration purposes here's a short example of the idea behind it: Consider the following xml-doc: <root> <testA> <stringA>A</stringA> <option>1</option> </testA> <testB> <stringB>B</stringB> </testB> </root> An Example query could look like this: exec stringMatch"A+1,B" this would match the above mentioned code, but stringMatch"A,B" is wrong because A+1 is different than just A. The option-element can consist of -1 and 1 or it is not used at all, as in <testB>. I've included a...
A Tool is needed, which replaces specific characters (mostly control characters from 01 to 1F) in a CSV file. Input: CSV file - It must be possible to pick a CSV file. The CSV file is semicolon (;) separated, and if a value contains spaces or specific characters, that value is embedded in quotes ("..."). (CSV standard) Processing (in this order): ...two bugs during that cycle, and I will not find bugs and correct the function myself. You agree that you will lose arbitration in case you deliver a function that is not working as specified on the second delivery. In other words, please test your code thoroughly before you deliver and do not rely that it will work. ## Platform SQL Server 2000 Please note this is for SQL Server 2000 and TSQL, not a com...
A Tool is needed, which replaces specific characters (mostly control characters from 01 to 1F) in a CSV file. Input: CSV file - It must be possible to pick a CSV file. The CSV file is semicolon (;) separated, and if a value contains spaces or specific characters, that value is embedded in quotes ("..."). (CSV standard) Processing (in this order): ...two bugs during that cycle, and I will not find bugs and correct the function myself. You agree that you will lose arbitration in case you deliver a function that is not working as specified on the second delivery. In other words, please test your code thoroughly before you deliver and do not rely that it will work. ## Platform SQL Server 2000 Please note this is for SQL Server 2000 and TSQL, not a com...
An SQL Server inline function is needed, which replaces specific characters (mostly control characters from 01 to 1F). Input: text, varchar - The inline function will be used in queries, so fields of above types can be passed to the function and processed online. Note these fields are not Unicode. Processing (in this order): 1. If a field cont...two bugs during that cycle, and I will not find bugs and correct the function myself. You agree that you will lose arbitration in case you deliver a function that is not working as specified on the second delivery. In other words, please test your code thoroughly before you deliver and do not rely that it will work. ## Platform SQL Server 2000 Please note this is for SQL Server 2000 and TSQL, not a compiled .NET...
Por favor, regístrate o inicia sesión para ver los detalles.
We require an ANTLR 3.2 grammer for parsing an MS SQL Server (up to version 2008) SELECT statement. This should include full support for all reserved keywords and functions as well as full support for subqueries.
Hello, I am looking for someone who can create simple ASP.NET 3.5 website using C# language and MS SQL as the backend....offered to create an account, and when he creates an account watch list and items are getting saved in the db • So as you see db schema should be as: o User has 0 to many watchlists o Watchlist has 0 to many items • When user logs in he should see the list of his watchlists and search form • No web design is required! • This is purely programming task for someone with ASP.NET 3.5, MS SQL and TSQL experience.. Easy one and I can help you with the existing DB schema… • You should expect to create user tables, watchlists table and watchlists to products table and couple stored procs Please ask questions before bidding! Dumb...
Hello, I am looking for someone who can create simple ASP.NET 3.5 website using C# language and MS SQL as the backend....offered to create an account, and when he creates an account watch list and items are getting saved in the db • So as you see db schema should be as: o User has 0 to many watchlists o Watchlist has 0 to many items • When user logs in he should see the list of his watchlists and search form • No web design is required! • This is purely programming task for someone with ASP.NET 3.5, MS SQL and TSQL experience.. Easy one and I can help you with the existing DB schema… • You should expect to create user tables, watchlists table and watchlists to products table and couple stored procs Please ask questions before bidding! Dumb...
OBEJCTIVE: WRITE tsql STORED PROCEDURES for 1 database to be run as jobs. The database contains 2 Schemas and 96 tables but no stored produres yet. The stored procedures will only use 20% of all the tables. TASKS TO PERFORM: ----------------- 1. Requirement (1 hour). Read through the requirement doc as a baseline to create the stored procedures the ETL scripts as Stored procedures to transfer data from between the two schemas.(1 day) 3. Stored procedure 1 represents a hierarchic structure in the destination table, I have already scripted this script and you can just plug it into the stored procedure. (1 hour) 4. Create Error handling for all the stored procedure based of the requirement doc ( 4 hours) 5. Write a documentation about all stored proc...
Hi we are looking for a experienced mySQL Professional who has sufficient proficiency in TSQL (SQLServer). The task is to take an existing STORED PROCEDURE and an existing FUNCTION that have been both written in TSQL and port them to mySQL stored procedures. The job is not huge (less then 50 lines of code) but needs to be done fast and professional. It will not take more then one day of work. You should be fluent in English and able to communicate (chat and voice!) over Skype. You should have expirience dealing with huge amount of data and time critical applications. Looking forward to hear from you Sven IMPORTANT: WE DEAL ONLY WITH SINGLE FREELANCERS - WE DO NOT HIRE FRIMS, COMPANIES, TEAMS. Do NOT BID if you are not a single freelancer.
Must have knowledge in VBnet Gridex SqlServer 2000 TSql MSWord object (merge) Reports (prefered: MS report rather than Crystal report) MSAccess (primarily: VBA routines) ADOBD object I am in a pre-qualification process to select a programmer for several small tasks and interested to continue working on several larger tasks in the next 6-12 months in case of success. We will start with routines or small applications expected to take anywhere between 4 hours to a couple days. The deadline is flexible.? For convenience, I am creating only one RAC taks, but when we agree on a task, I will create a new RAC task to avoid any ambiguity. Further work will continue to be handled with additional RAC contracts (hopefully private bids) Examples of...
We require additional functionality to be developed for a bespoke web application. This functionality will allow the client to create a PDF by building the document using a number of pre-defined sections. These sections will provide the relevant form fields and functionality to save the required data. The user will be allowed to order these sections by dra...number of pre-defined sections. These sections will provide the relevant form fields and functionality to save the required data. The user will be allowed to order these sections by dragging them into the required postion (along the y-axis). Once all data is set and positioned, the user can then request the PDF which is generated from the defined sections and data. Skills required: - MSSQL / TSQL - ASP.net C# - Javascr...
I have two tables, one storing aggregated (daily) transactional data (points, date) and another with defining kickback campaigns (points required, exchange rate, max amount<nullable>, valid from, valid to<nullable>). I need to extend a stored procedure of mine so that it calculates the kickback earned during a given time span, multiple kickback campaigns ma...need to extend a stored procedure of mine so that it calculates the kickback earned during a given time span, multiple kickback campaigns may run at the same time, some may have a max payout amount some may not (null), some might also be valid forever (null). I need this done asap, estimated time 1~2 hours. You need to speak fluent english and have very strong skills in MS SQL Server 2008 (TSQL) to complete...
I am a new SQL DBA , i need to upskill myself I want an experienced SQL DBA 2000 or 2005 to give me 8 hours training in the following:- 1-? ? 3 hours Perfroamnce tuning practical examples 2-? ? ? 3 hours practical examples on MS BI (reporting an analysis services). 3-? 2 hours Replication and mirroring and log shipping pract...practical examples 2-? ? ? 3 hours practical examples on MS BI (reporting an analysis services). 3-? 2 hours Replication and mirroring and log shipping practical examples? I have SQL SERVER 2008 machine , you can log to it from internet and you show me how. ## Deliverables You may need to give me some pdfs to read or documentation of what you are teaching me . screen shots and TSQL code may be also required as part of the doc...
Por favor, regístrate o inicia sesión para ver los detalles.
...header section and a few very small things). You don’t need an iphone an order to test the website you can use websites like the following: [][1] Data: The data that will be used for those reports is a data which contains information about vehicles. We will provide you with all the assistance required in order to query the tables in the database. You will not have to write TSQL or get good understanding of the data. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer...
...directly but I can't get anything to happen through php... Unfortunately this box isn't open to the world so this job will have to be through chat with you directing me. I would prefer this was done without recompiling php... At the moment all I'm receiving is error messages, eg: Call to undefined function odbc_connect() Call to undefined function mssql_connect() This connection to freetds: /usr/bin/tsql -S -U Does produce the expected 1> prompt though. I can also connect via isql, but not php. When I looked at phpinfo() I noticed something strange: --with-unixODBC=shared,/usr' as well as '--without-odbc''--without-unixODBC' All assistance must be provided via the command line. Thanks! ## Deliverables 1) Complete and fully-functional ...
...new type as parameters if possible, or I can edit the script to set in it old and new type somehow. How it is easier. * * *This broadcast message was sent to all bidders on Monday Sep 7, 2009 2:34:11 AM: Hi, I just added the backup of my db you should use for tests and review What I am particularily interested is to increase the type of StringID type, but as I mentioned I want this tsql script generic so I can change any other userdefined type later Thanks * * *This broadcast message was sent to all bidders on Monday Sep 7, 2009 12:22:39 PM: Hi, The original script I made is in attached db, stored proc [util_ChangeUserDefinedType] The only problem is when the columns are involved in relations. In this case the script fails. The solution is: ...
I have a tbl_Member table that has a LastName column. I need a computed column called LastNameOnly that returns everything in the LastName column up to the first non-alpha character. For example: Smith III --> Smith Hines-Albert --> Hines Lennar Homes --> Lennar Williams, Inc. --> Williams I need someone to create this computed column field definition. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in r...
...save the objects/records in viewstate. If you have a lot of records, the view state could get large. The proposed solution is to using custom paging and do the paging on the sql server. The grid needs to be fully sortable. A good reference point: :en-US:official&client=firefox-a Please provide all source code, including tsql, tables, xhtml, and c#/vb code. Article and code must be original. Please post the source an article my site at http://www.sagengage.com. Register for a new account, provide your author details in my profile. As of this writing, the source upload is not functional, so please simply message me the zip file. In addition, anyone that you can refer to the site that writes an accepted article, I will
I'm looking for some TSQL that will find tags in a data field (ideally varchar, Text, and nvarchar fields).? It should take tag delimiters (e.g. "{" and "}") and return all text found within such delimiters (ideally all unique text values found within such delimiters). For example, if I have data like the following: ? ? ? ? ? ? ? ? Dear {fname}, ? ? ? ? ? ? ? ? You have {count} items. ? ? ? ? ? ? ? ? Thank you {fname} Then if the TSQL is run with "{" and "}" as tag delimiters the following list would be returned: {fname} {count} ## Deliverables not much more to say.? Tag delimiters should be configurable (eg. I may want to use ">" and "<" to find html tags, etc.). ...
Convert 2 Microsoft Access 2007 Forms linked to SQL server 2008 database to .Net web forms. The Form includes a complex VB procedure that needs to be? converted? from VB. (I understand in SqL Server 2008 that this does not need to be in TSQL). ## Deliverables * * *This broadcast message was sent to all bidders on Tuesday Jun 30, 2009 4:32:49 PM: Hi. I received quite a few requests for more information. I will prepare a more complete document and send out to all bidders. Thank you, Finlay * * *This broadcast message was sent to all bidders on Wednesday Jul 1, 2009 5:23:38 PM: Hi, I attached a new more detailed document. rgds, Finlay * * *This broadcast message was sent to all bidders on Sunday Jul 12, 2009 4:09:40 PM: All, after answering quest...
? I have 5-6 MS TSQL queries that I need written for a homework/class assignment. All involve the latest version of Adventureworks DB The hardest part involves concatenating multiple rows of strings into a single comma delimited result field. All the others involve only simple joins and Sums (sales etc) Shouldn't? take an experienced SQL guy more than 30 minutes at most... attached zip file explains queries in detail ## Deliverables see attached
? I have 5-6 MS TSQL queries that I need written for a homework/class assignment. All involve the latest version of Adventureworks DB The hardest part involves concatenating multiple rows of strings into a single comma delimited result field. All the others involve only simple joins and Sums (sales etc) Shouldn't? take an experienced SQL guy more than 30 minutes at most... attached zip file explains queries in detail ## Deliverables see attached
1,000 word article on SQL Server Insert, Update, and Delete for beginners. All content must be original without cut and paste from BOL.? The article should be geared fo...how to type article, rather than a line by line description of each feature option.? ? The link below is unrealted to this exact assignment, but gives a nice feel for an articles structure. <> Try to spend approx equal time on each; Insert, Update, and Delete.? Both TSQL and the Management Studio Query Designer can be explored. Article should be delivered within 10 days of accepting assignment. ## Deliverables Article is to be completed in English and submitted in MS Word or notepad.
I have two columns in a database table.? One has HTML code in it and I want a script that will remove all HTML tags from the column? with html? - replacing the "<br />" tag with? CHAR(13) + CHAR(10) - and place the resulting text in the other column.
OBEJCTIVE: REWRITE TSQL STORED PROCEDURES OF 2 database, one stagging and one production database. The production database contains 22 tables, 61 stored produres, 8 functions totalling 8000 words. The stagging database contains 37 tables, 140 stored procedures, totalling 20000 words. Most of the stored procedures (90%) are duplicates where only one line changes in the code. Most of the table (80%) have the same structures but different names just because they are resulting the imports of files with different names but the same structure. TASKS TO PERFORM: ----------------- 1. Immediate action (3 to 5 hours). Write scripts to simplify the table structures in stagging and drop the useless tables. 80% of the table and the stored procedures are redundant. 2. ...
Make an AJAX file that lauches long running stored procedure (2 hours) and keep the status updated. For each stored procedure launched, another stored procedure keeps the client informed about the progress in %, and this is the second stored procedure that should be called after the first one is called. On the page, several stored procedures could be called simultaneously, and therefore several progress updates can be seen. If the long stored procedures as input parameters, it should be automatically explored using SQL parameter discovery and the user could have the possibility to fill those parameters on the web page. in , the list of available long running stored procedures is informed (not the parameters since they are aut discovered). WWF Workflow is required on the web ser...
I need eight functions to use from TSQL (SQL Server 2005) for conversions to and from hexadecimal in special formats. A couple are very simple, a couple are interative. If these can be written in VB.NET and made available to TSQL SPROCs, that would be great. If not, the need to be coded as SQL functions. ## Deliverables I need these converters to be as efficient as possible. That's why I would like to see them written in VB.NET or C#.NET.? These CLR scalar functions can then be made available to TSQL SPROCs. (I will need help knowing how to bring them into the SQL Server 2005 system.) The alternative is TSQL user defined functions but I fear that TSQL would be slower for this kind of thing. See function? details in the? attach...
I need a stored procedure (T-SQL, MSSQL 2005) that returns a list of availible addresses from a database. buy_orders_pallets (table 1) (contains what clients want to buy) bid int <- passed as parameter to SP pid int amount int isdry bit customer_avi (table 2) (contains what clients want to sell) pid int <- pallet id aid int <- address id (This is what I want returned) amount int isdry bit Here is the two tables, I want a SP that takes 1 parameter (bid) as input. use this bid to get rows from table 1 Then return all address id (aid) from table 2 where ALL of the following criteria is met. 1. all pid from table 1 is inside table 2 (matching the aid) 2. amount is equal or greater in table 2 than in table 1 3. isdry is equal Example data below wou...
...will need to be converted to code.? The application is already structured to allow the database to be replaced.? There is an an assembly for each module that loads and stores data.? The stored procedure and SQL Data Provider assemblies will need to be converted to have the same classes, but to call the SQL Statements directly rather than execute a stored procedure. The installation scripts (TSQL) will need to be converted or replaced. One concern is that SQL Compact Edition is not multi-threaded or multi-user.? I am open to using a different tool instead. ## Deliverables The deliverable for this project will be source code and compiled code that is able to allow the current ASP.Net web applicaiton to run and complete a series of tests involving browsing pages and...
...11:00 PM 3 1 11:00 PM 12:00 AM 1 1 6:00 AM 9:00 AM 3 The records starting with 8:00 PM and 11:00 PM are consecutive with the records before them. The result I would need would be SSN TimeIN TimOut ConsecutiveHours 1 11:00 PM 12:00 AM 12 The result would show the TimeIn/TimeOut time at which the consecutive hours ended. I will give you the real data as an excel spreadsheet which you can insert into TSQL. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Del...
Need some help setting up a performance tester for a MS SQL 2005 server. Someone who could help me run through this (maybe over MSN Messegner/Skype) would be great: <> But any ready made Csharp tool, or even TSQL script which can give some performance stattics on a DB sever running commands on a Northwind database would be fine. Thanks, Nick ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables
we need a TSQL Script to import data from an access database into a mssql server database. the first datarow from Kunden is already entered into the tables in the database. ## Deliverables 1) Complete and fully-functional working program(s) in Script form as well as complete source code of all work done. 2) * * *This broadcast message was sent to all bidders on Saturday Oct 6, 2007 2:16:47 PM: hello due to higher complexity and to provide more detailed information we decided to repost this bid request. please check the changes and repost your bid. if there are any questions (take a look at the pdf file) feel free to ask. best regards, milmi ## Platform Windows 2003 Standard Server MSSQL Server 2005
we need a TSQL Script to import data from an access database into a mssql server database. the first datarow from Kunden is already entered into the tables in the database. if needed, we can provide more information about the structure of the nuw database. ....................... some additional infos: this is only a part of a bigger data movement process. if we are agreed with the work done we like to request the coder to work on bigger parts for us. new zip added with mdf and ldf files. there are only a few sample datarows in the access table. in the final table there will be much more rows. the script has to run with more rows too. at the end, the script should print out, how many rows were imported and which rows where not imported. these tables in the target mssql database shou...
...time, then we could use Index server, google desktop or similar component to build an index of keywords present in the text and we would populate appropriate new tables in Sqlserver A commercial programs is an other acceptable solution (we can buy a licence). I would need help to put it in place. We are using Sqlserver2000 - no immediate plans to upgrade Any programming must be done in either TSql or VBnet. We prefer MS components (I am very reluctant to use MySql for example) The solution must be Sqlserver compatible (ie: it must be easy to call it from Sqlserver so as to integrate the search with other functions/fields...) a web service could be acceptable too ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete so...
...uploading data captured by specialists working from laptops in remote locations. We would like to find people we can add to our team so we are very interested in people that want to work with us for years. Here are the skills we are looking for: Required: * C# * .NET 3.0 * ASP.NET * User Interface Design (this is apparent from the types of applications the person builds) * Microsoft SQL Server 2005 * TSQL Nice to have: * Web Forms * Crystal Reports (or Business Objects) * Stored Procedures * Microsoft Enterprise Library All bidders must answer the following: (1) What is your hourly rate? (2) What is your availability? When can you start and how many hours per week can you devote to our work? (3) Are you interested in working with us long term? (4) Fully describe your experience w...
Por favor, regístrate o inicia sesión para ver los detalles.
We are looking for a s...(no hand-holding!). Must have development skills (if you donât have skills 1-9, they please donât apply) : 1. ASP .net (v1.1)/ VB .net (3 years minimum) 2. HTML/CSS (with AA accessibility in mind) (4 years minimum) 3. PHP (v4+) (2 years minimum) 4. MySQL (2 years minimum) 5. JavaScript (4 years minimum) 6. SQL Server 2000 (3 years experience with stored procedures and general TSQL) 7. Visual Studio 2003 (3 years minimum) 8. Apache 2+ ( 3 years minimum) 9. IIS 6.0 (3 years minimum) 2002 (ideal but not required) 11. Code versioning with sub-version would be a bonus 12.A good grasp of OO architecture and concepts 13. AJAX experience a bonus NB. NO REMOTE WORKERS!âŠIF YOU ARE NOT WORKING IN LONDON THEN DO...
We are l...hand-holding!). Must have development skills (if you donât have skills 1-9, they please donât apply) : 1. ASP .net (v1.1)/ VB .net (3 years minimum) 2. HTML/CSS (with AA accessibility in mind) (5 years minimum) 3. PHP (v4+) (2 years minimum) 4. MySQL (2 years minimum) 5. JavaScript (4 years minimum) 6. SQL Server 2000 (3 years experience with stored procedures and general TSQL) 7. Visual Studio 2003 (3 years minimum) 8. Apache 2+ ( 3 years minimum) 9. IIS 6.0 (3 years minimum) 2002 (ideal but not required) 11. Code versioning with sub-version would be a bonus 12.A good grasp of OO architecture and concepts 13. AJAX experience a bonus NB. NO REMOTE WORKERS!âŠIF YOU ARE NOT WORKING IN LONDON THEN DO...
Create 2 TSQL queries that traverse a tree structure and output A) a dataset and B) a generated TSQL select statement. The attached file contains the DDL of the tables and a description of what the queries should return. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buy...
Work on a monthly basis as part of a project team. Experience with TSQL and dynamic SQL. Experience with Reporting Services and Crystal Reports a plus. Looking for 2-3 programmers. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that...
Need Custom TSQL Crosstable query or Sproc created - see file attachment for spec Please note that the SOURCE data table I have in the attached text file and the desired RESULT data table data to not exactly match , the sample is to show the desired result format only.... (the shipping prices to do not exactly correspond to the source data) ## Deliverables Just need the TSQL in plain text file ## Platform MS SQL 2005
Need Custom TSQL Crosstable query or Sproc created - see file attachment for spec ## Deliverables Just need the TSQL in plain text file ## Platform MS SQL 2005
The DBA will create a TSQL script to create a stored procedure with the ability to describe the columns of a table that is passed in as an input parameter. Input: TableName Output ColumnName, DataType, AllowNull, IsPrimaryKey Basically I am looking for a list of the columns for the table with the DataType returned as a string; example varchar(30). AllowNull will be 1 of the column allows nulls, 0 if not. IsIdentity will be 1 if the column is the primary key of the table, 0 if not. Thanks for bidding. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web s...
...a graphic design, using CSS - Cutting graphic elements from PSD files ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows: a) Ready-to-install package for the server with clear and easy installation instructions b) Database scheme in TSQL code 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Consumer side ...
...It's simple we have the leading nine best selling phones- 3 networks- tariffs - promotional items- deals- cart - customer login - place order- no transactions An emailed link is sent to a sales team, who then look at the order and assign an order status. Mobile Phone Eccomerce site: Work done: domain hosting services etc Database Design Basic Website Design look and feel Work To Do: TSQL query writing Product Information and image sourcing Data Loading to database Dynamic Product Catalogue customer login shopping cart Secure Ordering Processing & Management Online Payment System Integration (simple, no transactions required, just credit card storage) Online Shopping System (buy this phone) Inventory Management Sales Analysis & Site Tracking ...
I need the attached MS Access query to be rewritten in TSQL. The problem is that the columns are dynamic and the PIVOT statement will not work from what I can tell. TRANSFORM Last(Job_1.J_Value) AS Row SELECT Job.J_JobIdent AS RecordID FROM (Job INNER JOIN Job AS Job_1 ON Job.J_JobIdent = Job_1.J_Relation) INNER JOIN Content ON Job_1.J_Attribute_04 = Content.C_ContentIdent WHERE (((Job.J_Name)="Job") AND ((Job_1.J_Name)="Value")) GROUP BY Job.J_JobIdent ORDER BY Job.J_JobIdent DESC PIVOT Content.C_Value The Access database has been created. ## Deliverables All I need is a working stored procedure that I can run that will give me the same results that I get in the Access query. I can provide the Access database. ## Platform SQL 2000 ...
I need a SQL Server 2000 stored procedure to do a search and replace of text within a field in a database. I have a table called Topic with a column name of Description of type ntext. I would like to replace these strings inside the column: <SPAN style="FONT-WEIGHT: bold"> with <strong> </SPAN> with </strong> The coder will deliver the create stored procedure TSQL. This stored proc needs to execute on a Insert or Update trigger. I haven't done a trigger before so a short description of how to do that is needed. I need this done as quickly as possible. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-t...
