I was just about to update the post, adding a link to...

Luis Cazares (8/12/2014)

---

This might not be the correct version (I'm not sure if there's one for 2014) but it can help you out.

http://www.amazon.com/Microsoft-Server-Fundamentals-Developer-Reference/dp/0735658145

You could also read some of the stairways...

pratiksawant28 (7/21/2014)

---

Hi,

I have an database name ABC. In this DB i have table name XYZ.

This table has the rows more than 1000, but suddenly from yesterday is was showing only...

Further on mickyT's post, ISNUMERIC returns 1 for more than just numbers as the sample below shows

😎

USE tempdb;

GO

;WITH T(N) AS (SELECT N FROM (VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL)) AS X(N))

,NUMS(N) AS (SELECT TOP(255)...

Thank you Perry for this nice piece.

😎

Jeff Moden (8/12/2014)

---

Howz about we just track the buggers down and take them out for a nice pork chop dinner, Moden style? 😛 It might also decrease the surface...

Unless I really got it wrong, the sample data you provided should not return any records as the Tab2 effective_date is greater than the values in Tab1 effective_date, hence nothing...

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...