Jeff Moden (1/16/2015)

---

halifaxdal (1/16/2015)

---

Hello, I have a script to be used to backup a specific table in a weekly basis, here is the approach what I take, if you have...

shouldn't it read: While the Server and ConnectionData fields may seem redundant,...

r.szasza (11/24/2014)

---

I've found some interesting thread here:

http://stackoverflow.com/questions/3169220/export-query-result-to-csv-file-in-sql-server-2008

The .CSV file...

Tried that already and it threw some other pre-req

Thanks for that, l am sure it works in your situation but rather like to have a one query like openrowset solution.

Thanks Luis,

The article might be helpful to someone, but the author is really making things way too complex, it won't pass the code review in my work place.

Joe Bloggs-301800 (10/29/2014)

---

The easiest way is to paste the URL into json-csv.com. This will generate a CSV spreadsheet. Then you can either copy the CSV text from a...

ricva (11/19/2014)

---

I believe I can.

Do you have an example of the json data and the table you want to put it into?

Would you call a stored proc from...

didn't look into it as I've been drag away by other project, if you have example or any finding, please post it here, thanks

MMartin1 (11/4/2014)

---

Is this still an ongoing issue. I wouldn't mind DDL statements with some sample data if so. Are the columns in your where clause properly indexed and statistics current?...

vincyf1 (10/23/2014)

---

halifaxdal (10/16/2014)

---

GilaMonster (10/16/2014)

---

Developer edition is the equivalent of Enterprise edition in terms of features, but it is licensed for non-production usage only. You may not use it for production...

Since the hierarchyid is causing the problem, I took further search on this type and was able to find a way to convert it into varchar and successfully import it...

Your guess...

patrickmcginnis59 10839 (10/22/2014)

---

Well its more complicated than I thought, so much for me trying to help LOL

First off, we need the type "flag".

Can you post that type "flag?" Its in...

Thank you Patrick!

SQL_Latin1_General_CP1_CI_AS

Database: AdventureWorks2008

Table: [HumanResources].[Employee]

USE [AdventureWorks2008]

GO

/****** Object:...