Alvin Ramard (6/19/2015)

---

Phil Parkin (6/19/2015)

---

richardmgreen1 (6/19/2015)

---

Hi all

I've got an SSIS package that loads a block of CSV files from a specified folder and moves them to another folder after processing...

richardmgreen1 (6/19/2015)

---

Hi all

I've got an SSIS package that loads a block of CSV files from a specified folder and moves them to another folder after processing them. It then...

A brief search suggested this.

nidhi.naina (6/18/2015)

---

Hey..

Thanks.

removing the index helped by bringing down the time to 6 seconds.

Can you please help me with why it might have been used in first place. (possible...

Jonathan Marshall (6/18/2015)

---

Hello everyone,

I have been giving the task of profiling databases and all the tables within it.

Right now I'm collecting the following:

Null_Count

Null_Percentage

Total_Record_Count

I'm looking to capture Mean_value, Min_value,...

nidhi.mahajan (6/18/2015)

---

I have this simple select query in a proc and the query is taking approx. 30 seconds to return approx 35000 records.

I am a beginner. 🙁

Can you please...

Have you tried selecting Query / Results To File?

Not quite – that one is synchronous. I've looked for a decent example and cannot...

It doesn't seem to work like that.

The release seems to lag behind everything else by (quite) a few months. When it is released, it is released as a standalone module/package...

You mean for SSIS etc?

They're usually quite a long way behind. You may find this[/url] page of interest.

Douglas Osborne-229812 (6/16/2015)

---

I'm getting data from another system in a stream of <column> <Value> pairs, as below

Column1 100 Main Street

Column2 Appt #1

Column3 Havertown

Column4 PA

Column5 19083

Column5 0121

Column6 USA

Column7 S

Column1 200 Main...

Simple enough: in table A, you have a row containing CheckValue = 60 which matches three rows in table B, hence three results.

DSNOSPAM (6/16/2015)

---

I caught that 'sp' instead of 'fn' and changed that in my code. Oh crap, the problem was that I had two different versions because of that 'sp'...

Your function should be schema-qualified too.

And prefixing it with sp is very confusing!

DSNOSPAM (6/16/2015)

---

Thanks everyone. I didn't catch those mistakes. However, I'm still getting zero.

alter FUNCTION spGet_Rec_Count

(

@source_tbl varchar(100)

)

RETURNS bigint

AS

BEGIN

-- Declare the return variable here

DECLARE...