You really just need to get a connection to the SQL Server from your Unix box. A quick search for SQL Server Linux Client got me to http://richbs.org/post/43142767072/connecting-to-microsoft-sql-server-from-unix-linux-mac

That page will...

When you have a situation like this, there are a lot of places that have tools that will automatically run through all the diagnostic information for you.

One of my favorite...

I would take a look at the BCP utility.

If you use -c it will convert everything to a char type and use a tab as a separator so you...

SSRS has a built in export to CSV. Would that work to get a text format?

In a multi-threaded application, anything that isn't thread safe should be wrapped in a sync lock. This makes it so that only one thread can enter the sync lock section...

If you change your UNION to a UNION ALL, it will work. Note that it will not filter out duplicates like UNION will.

I think the same issue can be had anywhere. It might be less likely to happen if reports are developed by the BI experts because we know how to test...

This kind of depends on what your security needs are. If you just want everyone to be able to be able to get to the reports, then you can do...

Another option is to use a tally table.

See http://www.sqlservercentral.com/articles/T-SQL/62867/%5B/url%5D

and go down to the section dozens of other uses. What you're looking for is in that section.

Oh yeah, you have the convert in there, which returns a VARCHAR type. So even though it's displaying numbers, the datatype is VARCHAR.

You can move the AVG function directly around...

Steve-0 (11/4/2013)

---

Hey Everyone,

I'm new to writing SQL queries and I'm a bit stumped in this one. The below query currently defines a total elapsed time of specific jobs that I...

That sounds like a permissions issue with the folder where you're trying to put the text files. We're doing something similar and we have a shared folder set up with...

Typically what you do is something like...

(This is a generic table to illustrate the process)

CREATE TABLE #tmp

(

Col1 INT,

Col2 VARCHAR(50),

Col3 VARCHAR(50)

)

And then you insert into the temp table for all the...

I haven't looked up the error code, but at a guess, I'd say the server was unable to get information from your domain controller.

The best thing to do is to...

The first thing that comes to mind is to make use of a temp table or a table variable. Insert your delivery information into a temp table, and then update...