Cancelado

MS-SQL Server Trigger Writing

Hello, this should be easy money for you if you know your database work. I have a table in a ms-sql database. This table has a column that takes readings with a time stamp called CHECKTIME. I want to create a trigger that will look into the previous entry and check the USERID, CHECKTIME, CHECKTYPE and SN, If the USERID and CHECKTYPE and SN are the same and CHECKTYPE is taken within 1 minute or less, it will not allow it to enter, it can be at the INSERT or after INSERT. The entries will happen at a fast rate, 2-10 seconds apart so your trigger should be ready to handle fast entries without causing issues to database.

Check the screenshot to know how the table is structured. It shouldn't take you more than 1hr maximum if you know your SQL.

Update: If the USERID and CHECKTYPE and SN are the same and CHECKTIME is taken within 1 minute or less, it should not allow it to enter in table

Habilidades: Microsoft SQL Server

Ver mais: sn it, sql less than, MS SQL, MICROSOFT SQL SERVER, database microsoft sql, fast screenshot, check sql, sql server database issues, create table sql server, make data entry script sql server, fast entry sql database, code writing sms server, writing media server, writing xmpp server, create entry sql, sql server insert, sql insert, excwl sql database enter data, writing script server, create look stamp, table sql server, sql table writing, data entry form sql server 2005, sql server create database, writing ftp server using

Acerca do Empregador:
( 2 comentários ) Berlin, Germany

ID do Projeto: #6835998

12 freelancers estão ofertando em média $28 para este trabalho

abdellatif81

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft database Mais

$49 USD em 1 dia
(4 Comentários)
4.0
acronymsolutions

Hi, I have gone through your requirements, I am a Database Programmer at CMMI-5 Level company since August 2004.I am working on MS Access, Shell Script,PL/SQL,T-SQL,MySql,MSSQL Server,PostgreSQL,Oracle database, Le Mais

$25 USD em 1 dia
(2 Comentários)
3.8
mpalgeo

Hello i have written the trigger , If you still need it , please contact me to sent it to you. Best Regards mpalgeo

$20 USD in 0 dias
(10 Comentários)
3.4
truongnguyen86

Hi there, i'm expert on SQL Server, actually i've done many trigger related to DML and DDL, pls also check my profile to see what i've done before. Thank you

$40 USD em 1 dia
(6 Comentários)
2.9
blackjk

Hello! This is what you want? Pls rename YourTableName to the your real table name before using. CREATE TRIGGER IO_Trig_INS_YourTableName ON YourTableName INSTEAD OF INSERT AS BEGIN SET NOCOUNT ON IF (NOT EXISTS (se Mais

$20 USD em 1 dia
(2 Comentários)
2.8
MubashirAbbas71

A proposal has not yet been provided

$35 USD em 1 dia
(2 Comentários)
1.0
codetod

Hi The only way to stop an insert from a trigger is to do a rollback. This will return an error to the application which called the insert query - can send a customer error. If you try insert directly through an SQL Mais

$25 USD em 1 dia
(0 Comentários)
0.0
joaofmeneses

No problem for me. I work with SQL and postgreSQL every day. What type of error message do you want to get in output?

$55 USD in 2 dias
(0 Comentários)
0.0
tejasnshah

Hi, I have 9+ years of experience in SQL Server 2000/2005/2008/2012 and Web Technologies ASP.NET (VB), XSLT, AJAX etc. My MS SQL SERVER article on SQL SERVER CENTRAL, for Trigger, [url removed, login to view] Mais

$20 USD em 1 dia
(0 Comentários)
0.0
mirzataimoor

I have sound knowledge of database triggers in mysql. I can complete this task with ease. Please give me chance to work with you. Thank you

$17 USD in 2 dias
(0 Comentários)
0.0
ekajgho

Over 14 years of experience in Microsoft Technologies. MCTS (Microsoft Certified Technology Specialist) on Web Applications Development with Microsoft .NET Framework 4 (Exam Code: 070-515). Functional experience incl Mais

$20 USD em 1 dia
(0 Comentários)
0.0
zohaibshahid123

I am data analyst by professional, my most of work relates to your task . I am the right person to work on your task efficiently . Thanks

$23 USD em 1 dia
(0 Comentários)
0.0
drozhkov

A proposal has not yet been provided

$20 USD em 1 dia
(0 Comentários)
0.0