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...

This will be ringing alarm bells among seasoned users of the site, who will be wondering why you...

Don't use nvarchar. Use nvarchar(size).

DanMcClain (6/12/2015)

---

I think its great that Microsft does the early (not always perfect) for us early adopters. We have SQL 2014 in production utilizing Column store index, filetables, and In-memory....

Paul Sims-405749 (6/11/2015)

---

Phil, not sure I understand the question. When I branch and then open the branched solution the reference are there, however they are invalid. It's almost like these...

JOIN the tables.

Continuing with your theme of minimal information:

Select Name, Surname