bcp doesn't allow you to append data to an existing file.

You have a couple of options. You can output the data to two separate files and then concatenate them...

Yes, but are you having trouble getting the information to append to the file or do you have the information and you can't figure out how to append it?

We also...

Brandie Tarvin (10/10/2016)

---

Grant Fritchey (10/10/2016)

---

This was an... interesting? ... read. Weird location. I've never heard of this person. I think this is their only SQL writing. It's just odd.

No need...

Did you check to make sure that the agent has permissions to access the directory where the files are stored?

The last time I worked with SSIS was SQL 2008, so...

Your description does...

LinksUp (10/10/2016)

---

Putting MIN & MAX around strings to get the desired output is not, in my opinion, a good approach or technique to use. (Though I have done it myself...

wtren (10/8/2016)

---

beautiful work, I check the execution plan, the main cost is on sort operator, in fact we do not need that much sort, we just need sort the credit...

Sergiy (10/9/2016)

---

That's right.

If you want to...

eandre360 (10/10/2016)

---

Hmm, thanks for the support. I actually think that I managed to format to accommodate this. However, I'm getting an error for something that shouldn't be getting considered in...

Y.B. (10/7/2016)

---

drew.allen (10/7/2016)

---

Here is an updated version that only requires a single scan of the table. There is a complete description of the logic at New Solution to the...

Try the following.

DECLARE @t TABLE(doc XML)

INSERT @t (doc)

VALUES('

<AUDITS>

<Admin>

</Admin>

<provider_spells />

<Refno>123456</Refno>

<Action>UPDATE</Action>

<Fields>

<old_pmetd_refno></old_pmetd_refno>

<new_pmetd_refno>4110</new_pmetd_refno>

</Fields>

</AUDITS>')

SELECT f.fields.value('old_pmetd_refno[1]/text()[1]', 'INT'), f.fields.value('new_pmetd_refno[1]/text()[1]', 'INT')

FROM @t

CROSS APPLY doc.nodes('/AUDITS/Fields') f(fields)

Drew

Here is an updated version that only requires a single scan of the table. There is a complete description of the logic at New Solution to the Packing Intervals...

We said it was XML, not SQL, and XML IS text, but in a very specific format. Even if it's...

Luis Cazares (10/7/2016)

---

Here's a query with three conditions that should fulfill your requirements.

SELECT *

FROM #tmp

WHERE loginName LIKE '%_._%' --Has a period surrounded by other characters

AND loginName NOT LIKE...

I think that this is what you are looking for.

SELECT *, ROW_NUMBER() OVER(PARTITION BY Companyid, DateFrom ORDER BY DateTo DESC)

FROM #temp

ORDER BY CompanyID, DateFrom, DateTo

Drew