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/[/url]

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...

Having the query engine choose a scan instead of a seek isn't going to be affected by how fragmented your index is. An index, by definition, is the ordering of...

The best advice anyone can give about whether the time spent on the index reorg is normal is to take measurements and see what you normally get. The answer about...

In the past, I've done things like this using role based permissions. You can design the system differently, but a lot of the basic building blocks would be to have...