Quick thought, compare the results of these two queries

😎

;WITH DISTINCT_KIDS3 AS

(

SELECT DISTINCT

load_KIDS3_clients.idClientKey ,

load_KIDS3_clients.firstName ,

load_KIDS3_clients.lastName...

Similar discussion on this thread

😎

arooj300 (8/26/2014)

---

This is not a permission issue. Because from 1 year job is running, and we did not have any problem. But from two days job has started failing because...

Mr.Sahand (8/25/2014)

---

Hi everyone,

I need to run a VBA function in an MS Access database in SSIS.

I put a Execute SQL Task in control flow and link it to the...

Quick thought, is it possible that the initial code was double pasted? Below is what I would guess it should be.

😎

SELECT

tB.ORDER_DATE

,tB.COMMIT_NO

...

tony28 (8/25/2014)

---

Eirikur Eiriksson (8/25/2014)

---

tony28 (8/25/2014)

---

so what do you think, is any soulution than update statistics ? because with these high values I cannot use this procedure, this is very heavy...

tony28 (8/25/2014)

---

so what do you think, is any soulution than update statistics ? because with these high values I cannot use this procedure, this is very heavy for server if...

Here is a useful script from Paul S. Randal[/url], lists open transactions with plans and text

😎

SELECT

[s_tst].[session_id],

[s_es].[login_name] AS [Login Name],

...

Jeff Moden (8/25/2014)

---

BWAAA-HAAA!!! Me too!

I'll...

cbernardes (8/25/2014)

---

I am using the DTS wizard and having problems importing excel into an existing table.

Problem is that various column in excel are defined as double in the wizard but...

kaplan71 (8/25/2014)

---

Hello --

I have been monitoring the amount of time it takes for a Full backup to complete. The e-mail notification shown below provides an example of the current state...

Couldn't post this solution at the time because of a quirk in the forum, had to PM it.

😎

USE tempdb;

GO

/*

Item Location ...

jkalmar 43328 (8/25/2014)

---

Eirikur, with this test data the expected result set would be:

C1473045850 T1954 3730 ''

C1473045850 T1954 3731 ''

C1473045850 T1954 3732 ...

jkalmar 43328 (8/25/2014)

---

OK, let me try to get you guys what you need...

CREATE TABLE PRE_LOAD(

KitID varchar(20) NULL,

BatteryID varchar(20) NULL,

TestID varchar(20) NULL,

LBSTAT varchar(8) NULL

)

INSERT INTO PRE_LOAD

(KitID, BatteryID,...

Don't think this needs any explanation, too funny