This can be done more efficiently with a simple ROW_NUMBER implementation.

😎

The problem with your solution is that it scans the table 1+(2 x number of rows) times, fear it will...

Alternative method using Lynn's fine test set (with the addition of a Beginninator 😀 )

😎

;WITH testdata AS (

SELECT

Directory

FROM

(VALUES

('/dev/Mywork/deailsbyWork'),

('/dev/MyTeam/deailsbyTeam'),

('/dev/MySubgroup/deailsbySubgroup'))dt(Directory)

)

,FIRST_CHOP AS

(

SELECT

...

Piling on, don't use implicit convertion

😎

DECLARE @startdate DATETIME = CONVERT(DATETIME,'20160101',112);

Since you are on a 2012 forum then why not use a window function?

😎

Note that a POC index like this would be very helpful

CREATE NONCLUSTERED INDEX NCLIDX_#EXAMPLE_CUST_SALES_INCL_WIN_PRODUCT ON #example

(customerId ASC,...

jasona.work (5/26/2016)

---

I'm really starting to hate the SSIS Catalog...

Two servers, same permissions on both. On one, the user can deploy their project no problems (with the deploy project wizard.)

On...

Ray K (5/26/2016)

---

Hey Threadizens . . .

The other day (inspired by a couple of SQL Saturday speakers), I started my own blog.

My most recent entry tackles the very-often-asked-here-on-SSC question, "how...

cvoss85 (5/26/2016)

---

I have an SSIS package which includes a foreach loop to find a file and then archive it to a different folder once other steps are completed.

When I execute...

Quick question, can you post the DDL (create script(s)) for the tables, sample data as insert script(s) and the expected results?

😎

Same as before with the added columns, note the added calculated column and a covering index which improves the performance quite a bit, roughly 5 times faster than the self...

Luis Cazares (5/25/2016)

---

Gazareth (5/25/2016)

---

jasona.work (5/25/2016)

---

Eirikur Eiriksson (5/25/2016)

---

Brandie Tarvin (5/25/2016)

---

Brandie Tarvin (5/25/2016)

---

Sigh....

Quick suggestion

😎

Relies on the sum of the checksum of the identifiers so be aware that there is a change of getting a collision error

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(AFFILIATIONID,BACKAFFILID,ENTITYID) AS

(

...

Brandie Tarvin (5/25/2016)

---

Brandie Tarvin (5/25/2016)

---

Sigh. Wish wish wish I could get...

Jeff Sims-413169 (5/24/2016)

---

I am running a alter table tablename alter column columnname varchar(66) on a very large table, currently is INT. 1billion rows. Ran 11 hours but...

+100

Lot of logic and checks performed in the job...

rk1980factor (5/23/2016)

---

I have 3 tables A,B,C

Here are column and field names

A:app_no,app_name,app_add

B:b_no, B_code,B_rates

C:c_no, C_degree,C_humidity

There is common field in all 3 tables but their field names are different. (in above example app_no,b_no...