webrunner (11/30/2015)

---

It seems like the answers marked "This worked...

check to see if that querybuilder has a timeout. the 30005 duration looks a bit too suspiciously like a timeout. Just a guess tho!

patricklambin (11/19/2015)

---

patrickmcginnis59 10839 (11/18/2015)

---

patricklambin (11/18/2015)

---

Thanks for this interesting question. I have been able to answer it only because I have studied jobs ( and used them ) in September.

As several...

patricklambin (11/18/2015)

---

Thanks for this interesting question. I have been able to answer it only because I have studied jobs ( and used them ) in September.

As several posters , I...

Jeff Moden (11/18/2015)

---

patrickmcginnis59 10839 (11/18/2015)

---

Jeff Moden (11/17/2015)

---

Hugo Kornelis (11/17/2015)

---

I have never found or seen a method for computing running (pre SQL Server 2012) that has comparable performance to a well-programmed...

I think that Jeff's and Hugo's recollections are going to be biased, so I think a link should be posted for the more objective thread participants, and we can put...

Jeff Moden (11/17/2015)

---

Hugo Kornelis (11/17/2015)

---

I have never found or seen a method for computing running (pre SQL Server 2012) that has comparable performance to a well-programmed cursor solution, except for...

Here's a couple of vb.net examples with bound and unbound datagrids, guessing that its vb.net you're using, you should at least specify the language and whether your datagrid is using...

I don't think you're going to be able to run it this way.

https://msdn.microsoft.com/en-us/library/ms190312.aspx

This page says that the argument that you're trying to specify the instance in must be a "string...

try "sqlcmd" (without the underscore separating sql and cmd)?

"SQL is imperfect, certainly, but if all it is for is for data access, you might as well just use flat files."

LOL

Ah thats where I went wrong, thats a good way to do it. Often...

when you import into excel, do you use a unique column delimiter? I usually am pretty successful when I use a suitable column delimiter.

You could also consider hooking excel up...

Excel would probably do nicely with formatting, that would be one of my choices. Maybe you could also investigate building html from your query and just outputting that?

sqlcmd -S SERVERNAME -d DATABASENAME -W -h -1 -s "|" -i sql_query.txt >output_file.txt

-W remove trailing spaces

-h -1 remove column headers

-s "|" I like to use the vertical pipe as column...