Lynn Pettis (9/14/2016)

---

Eric M Russell (9/14/2016)

---

By setting the property RetainSameConnection = True on the Connection Manager, temporary tables created in one Control Flow task can be retained in another task....

xsevensinzx (9/13/2016)

---

Steve Jones - SSC Editor (9/13/2016)

---

You could do this in a header, but there's no enforcement. People make changes to procs, test them, make more changes, test, fix things,...

Same comment for SSIS: it's straightforward to do, but you wouldn't be able to use temp tables for that.

Gary Varga (9/14/2016)

---

JoeS 3024 (9/12/2016)

---

I think one reason why this could be is our global world. How many of us actually understand how to communicate with not only other...

ChrisM@Work (9/13/2016)

---

Jeff Moden (9/13/2016)

---

Curious... isn't that just moving the problem to something else? You still have...

Pivot-156509 (8/31/2016)

---

@matt-2 Miller (#4):Thanks for your help.

Next one: sorry, why do you search for -1?

select * from session_hist where sh_id=-1

SH_ID SH_USER_ID SH_GUID

-----------...

Just curious - why would you want a password hive with a SQL Server backend? seems counterintuitive to me (it's precisely what you wouldn't want IMO).

This should get you to the starting node:

with xmlnamespaces ('urn:schemas-microsoft-com:xml-msdata' as m,

'urn:schemas-microsoft-com:xml-diffgram-v1' as d)

select c.value('local-name(.)','varchar(100)') as datanodename

from XMLwithOpenXML

cross apply xmldata.nodes('//d:diffgram/ReportData') a(b)

cross apply b.nodes('*') b(c)

You should google SQLXML...

jharvey6 76850 (8/30/2016)

---

Thanks Matt. I'll give that a try. The Transtype is in the same location just inside the envelope. So, I can scan the element pretty easily. Where I...

If you want precision sub-minute - then you need to not use smalldatetime. per BOL:

Defines a date that is combined with a time of day. The time is based...

Well I've learned the hard way that when I run out of easy answers I need to check that my assumptions hold up 🙂 So mant times for me,...

That said - in the case you're showing, whether or not the actual output is ordered the same or not, the ROW_NUMER() is essentially ranking your sales folks by sales...

I noticed you didn't mention WHY it dies around 1.1M. If it gets that far before crashing I'd have to question if there's something odd in the file.

If there are...

It's hard to make an intelligent recommendation without a couple of representative samples. If the elements are NAMED the same, but just in different parts of the structure -...

This is all about setting up a "data-driven subscription".

It's been a while since I've had the pleasure of doing it but the basics are covered here:

http://beyondrelational.com/modules/2/blogs/101/posts/13460/ssrs-60-steps-to-implement-a-data-driven-subscription.aspx