ayazniazi (6/8/2014)

---

I have a for each container that is enumerating inside excel files. I have a file system task inside the container. The file system has to copy files from...

ayazniazi (6/8/2014)

---

I have a package and within that package I am executing another package using the Execute Package Task. I get the following error The LoadFromSQLServer method has encountered OLE...

Hi, and welcome to the forum. We need some help from you in order to assist you. Have a look at this article on the subject; How to post data/code...

Quick thought, is it an option to upgrade the VB6 application? VB 2008 has a conversion option, think that's the last version where it's included.

The problem sounds like the application...

Matthew.Procter (6/8/2014)

---

Hi all,

Got an issue that I can't work out. I have 2 tables, with "clientcode" field that in both is a varchar(50)

If I query the tables individually, I get...

Phil Parkin (6/8/2014)

---

+1

😎

For fun, a quick demonstration

😎

/* 250 Gb */

DECLARE @MY_NumberOfBytes NUMERIC(12,0) = 268435456000;

/* bytes */

SELECT

'Bytes' ...

Further Lynn's demonstration, here are few different ways the SQL Server handles NULL test (using Lynn's data).

😎

select * from

(

SELECT Column1, coalesce(Column2,0.0) as Column2

FROM NULL_TEST

) as x where x.Column2 <> 0

/*

[Expr1003]...

Another version, similar to Ed's, this one uses CTEs to construct the ranges.

😎

USE tempdb;

GO

DECLARE @num AS TABLE (

Id INT IDENTITY(1, 1)

,Price MONEY

)

DECLARE @range AS TABLE (

Id INT IDENTITY(1, 1)

,Rng MONEY

)

INSERT...

g.britton (6/6/2014)

---

Eirikur Eiriksson (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

gbritton1 (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

TomThomson (6/6/2014)

---

Just a couple of examples: A British colleague who held an A-level in math and a bachelor's in business swore...

SQLTougherGuy (6/6/2014)

---

Hello,

I am about to embark on a massive migration from SQL 2005 - 2008 R2. We have 200+ SSIS packages that were deployed as a file system on the...

TomThomson (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

TomThomson (6/6/2014)

---

Just a couple of examples: A British colleague who held an A-level in math and a bachelor's in business swore you could, in fact, divide...

Thank you for this filler Jeff, good read as always, and amazing thread! Only ran your initial code, any thoughts on how to eliminate the second scan?

😎

Koen Verbeeck (6/6/2014)

---

gbritton1 (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

TomThomson (6/6/2014)

---

Just a couple of examples: A British colleague who held an A-level in math and a bachelor's in business swore you could, in...

The Dixie Flatline (6/6/2014)

---

Eirikur Eiriksson (6/6/2014)

---

Agree on the costly part but exactly the same...