Here is a quick sample solution, much worse performance wise than Chris's but I put it forward more as an alternative method anyway.

😎

USE tempdb;

GO

;WITH TDOC(

[ID]...

Here is a quick SQL 2K8 solution, toggles by the flag changes using self-join, SQL 2012 solution would be easier with running total;-)

😎

USE tempdb;

GO

create table #test ( num int ,orig_time...

Here is a quick solution, adds a row number to join the two sets

😎

IF OBJECT_ID('Tempdb..#tTable1') IS NOT NULL

DROP TABLE #tTable1

CREATE TABLE #tTable1(ID INT,

...

daz.chauhan (8/28/2014)

---

Morning folks

Please can someone help with the format of a field? I have a number field (well I have hundreds on a number of reports) and I need...

My apologies if I was out of line earlier, somehow I get kind of agitated when requirements focus more on HOW than WHAT, especially when it's incorrect.

The problem itself is...

Hi and welcome to the forum, complements on the fine DDL and sample data!

Not too clear on what you are after but please bear with me as I'm only on...

errolthomasql (8/27/2014)

---

i am not sure how this will show up after changing the file extension. i wasnt able to upload as .csv

also, i am not going to be opening up...

Thanks for the question Shiva!

😎

Quick question, why the non-standard representation of negative numbers? Just open the file in Excel and change the number formatting.

😎

Brings back baaaad memories and resulting nightmares, when marketing, MIS, CRM teams etc. think there is a contained formula for email...

Again, quick question, what version and edition of sql server (select @@version) are you on? You do know that it is kind of offensive not to answer questions when someone...

Gazareth (8/27/2014)

---

No problem, shrinks are fine if you've just deleted/moved a load of data like you have here.

It's a good idea to run an index defrag/rebuild afterwards though.

Don't know how...

Robert Heynen-454800 (8/27/2014)

---

There seems to be an issue in regards to ANSI vs Unicode

When the file is viewed as an ANSI encoded file, both chars show

When the file is viewed...

rocky.paiano (8/27/2014)

---

Hello all

I am performing analysis of linked servers across 2000-2008R2 and need to find/build a list of linked servers that are truly active. For the sake of the...

ryetimothy (8/27/2014)

---

Someone I work with created the wrong ODBC connection and entered data in the wrong database (old copy on an old server that's about to be decommissioned) and I...