Wolfmeister (10/10/2016)

---

I have a client request to upload an Excel spreadsheet to Google Drive on a monthly basis, which I would like to automate - is this possible from SSIS?...

ramireddyjava (10/10/2016)

---

Hi Sir,Madam,

We are trying to implement global variables in SSIS. for example from development to UAT to production, the database details will be changed so that we need to...

Looks rather similar to my suggestion!...

Try this version too:

SELECT custid

, companyname

FROM sales.MyCustomers c

WHERE NOT EXISTS ( SELECT 1

...

Run them both in the same batch and check the relative costs.

Here's an alternative, though I'm not sure it's any better:

IF OBJECT_ID('tempdb..#Person', 'U') IS NOT NULL

DROP TABLE #Person;

CREATE TABLE #Person

(

PersonID INT

...

Grant Fritchey (10/7/2016)

---

The example looks like either XML or JSON. Do you know where the data is coming from? It's fine that it's stored in a VARCHAR field, but if...

XML, not SQL.

XML is text, but in structured format, with start and end 'tags' around data items.

niall5098 (10/7/2016)

---

thanks for the reply.

the column contain a string of data. within that string I will see the following entries:

<new_pmetd_refno>4110</new_pmetd_refno> ...

niall5098 (10/7/2016)

---

HI There,

as the heading suggests I am trying to query a text based audit for specific values then compare them values. For example the column should contain and new_ref_no...

Jeffery Williams (10/6/2016)

---

I will give it a try thank you. AND I don't have to count I just need to know if the result is greater than 0. Basically...

You have been here long enough to realise that this is...

Read the text files, check the errorlog,...

Lynn Pettis (10/6/2016)

---

If you are accessing the tables on the linked server and doing all the work on the local server, you are pulling all the data across the network...

Ed Wagner (10/6/2016)

---

Yeah, that's a good one. Be...