Since your are going to a larger data type I'm pretty sure you can just do something like this and still maintain the seed values.

ALTER TABLE myTable ALTER COLUMN myColumn...

tmmutsetse (5/30/2016)

---

The query that i am using looks like the one below.

SELECT

Name,

Memory,

Model

FROM [xxxx].[dbo].[Status]

where

active = 1 and

and name...

Brandie Tarvin (5/27/2016)

---

I just heard from my husband (who works at Deutsche Bank) that there is a holiday coincidence for Monday. A confluence of several countries having bank holidays at...

Back

Maybe it's just me but it seems like overcomplicating the matter. As Gail suggested just use a normal VARCHAR column which can be updated any time. This logic...

Black

Running

Either way I think you have everything you need. Rather than 'remove' the extra enter/exit just filter them out by name in your WHERE clause.

Savya (5/20/2016)

---

HI All let me make it more detailed. There are two exits continuously because a person can go to Facility room which is exit and then exit the building...

Luis Cazares (5/20/2016)

---

Just to be sure, because it's a common confusion. Are you using SQL Server?

In your post you mentioned autoincrement instead of identity (which is the word used in...

I think you are looking for this https://msdn.microsoft.com/en-CA/library/ms187342.aspx

This will return the last inserted identity value.

SELECT @@IDENTITY

You can then use that in a follow up insert statement.

CREATE TABLE #Customers (ID INT...

No J is right, the break time and work time are off if you introduce another...

Ok, here is my stab at it.

Notice I used minutes just because it was easier for me to verify the results but you can change it to whatever...

jasona.work (5/19/2016)

---

Brandie Tarvin (5/19/2016)

---

Greg Edwards-268690 (5/19/2016)

---

Brandie Tarvin (5/19/2016)

---

GilaMonster (5/19/2016)

---

Oooh. Am very tempted to grab both the R and the Data bundles.

The free...

Welcome to the forums.

Check this link out on how to post these kinds of questions here. http://www.sqlservercentral.com/articles/Best+Practices/61537/

Since this is your first post I'll give you this first one as a...