Suggest you have a look at the Time Zone Database, holds time zones and time change history.

😎

First guess without further information would be duplicate records in A1Warehouse.dbo.BINLOCAT

😎

Steve Jones - SSC Editor (8/12/2014)

---

Koen Verbeeck (8/11/2014)

---

GilaMonster (8/11/2014)

---

Maybe a throttle on posting new threads. A human can't...

cbrammer1219 (8/12/2014)

---

I am doing a Case statement to create a unified field for account type and vendor, in the code below I am receiving the error in the subject, because...

SQL_ME_RICH (8/12/2014)

---

You mean where I have it in the script(s) I am trying to call, listed as:

USE [CarePro_MSCRM];

GO

I should have mentioned that I tried changing that 6 different ways, but...

v4vaas 19815 (8/11/2014)

---

Hi, I need to use Bulk insert statement for copying a table with 200 million rows to another table on the same server...the table has no primary key...

Quick thought, remove the GO as it not an TSQL command/operator.

😎

Lynn Pettis (8/11/2014)

---

Eirikur Eiriksson (8/11/2014)

---

Ran it on 2K8 and reproduced your described results, don't have 2K12 at hand but there...

SQLRNNR (8/11/2014)

---

Somebody must have broken...

Ran it on 2K8 and reproduced your described results, don't have 2K12 at hand but there is some difference in...

With Packets: 1,441, Acks: 4,025, looks like a congestion somewhere:-D

😎

Something not right here, copyright owner with only water marked images! How on earth did you acquire the copyright?

😎

thiensyh (8/11/2014)

---

thanks bro, it's work like a charm!

Assume now my current date in table A, entity field is char

table data like below , but data in B & C...

There are quite few ways of doing this, here is one that uses left outer joins and a case statement:

😎

USE tempdb;

GO

/*

Table A - data example

Idno Entity Flag

1 1 y

2 1...

Quick question, I ran the code on SQL Server 2014 and it didn't show the behaviour described. What version of SQL Server (@@VERSION) are you on?

😎