Creating GoalSeek Function in SQL Server

Hi I have been working with MSSQL for over 15 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

hola buen dia!!! Parece como algo sencillo pero a la vez interesante!!! Contactame para platicar mas acerca de tus necesidades. saludos

HI. I AM A CERTIFIED MS SQL SERVER DEVELOPER AND TECHNOLOGY SPECIALIST. PLEASE FEEL FREE TO CONTACT ME AS I WOULD LIKE TO START ON THE FUNCTION ASAP. KIND REGARDS .ENRICO

I have almost 3+ years of experience in Application Development,Database Development, Database Optimizations, Database Design. Currently I am responsible for implementing complex business of this client at database side from data Design till development of modules. My Specialties are - .NET,C# - Database Designing - Database Development - Query Optimization. - Stored Procedures development For complex business - Views, Triggers and Functions development - SQL Scripting - Client Issues Fixations - Creating reports - Index maintenance - SSRS

Hi, I have been working with SQL Server since 2005, what you need it's not complicated and I can help you as soon as you need. Please contact me so we can start this job so you can tell me more details. Regards, Luciano.

Предложение еще не подано

Hello , i know goal seek function in excel. And i am 100% sure that i can make this function. Just give me a chance to start this work. Payment after 100% satisfaction. I am expert in MS SQL Server. Need more information of your actual need. How many input parameter you want in that function ? And how many type of operation you will be done using goalseek ? (like average,sum, etc.). I am ready to start work with you . Thank you .

A proposal has not yet been provided

2+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005. Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities. Strong technical background along with the ability to perform business analysis and write effective documentation and specifications. Expertise in T-SQL writing stored procedures, triggers and functions. Administering SQL Server High Availability and Disaster Recovery strategies. Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.

A proposal has not yet been provided

Hello Sir / Madam , I am basically a database developer , please find my summarized experience below : Having 7+ years of experience in MS SQL server Database and Multiple Heterogeneous database Has excellent database programming skills Has worked with very big company Schenider -electric , Honeywell , American reprographic company Has worked on several migration project and has transferred 100+ GB of data Have worked on SSRS reporting tool that can be very nice for developing Goalseek function here. Please refer my profile for more details. we also have qualified application developer in my contact to serve your need for any other complex bigger projects, if any. Thanks Chandan