Sean Lange (6/6/2016)

---

And let's consider the table valued function that uses a cte. If you slap a semicolon at the beginning doesn't that now make what could have been an...

You can try it for yourself. Set up an extended events session, capturing the lock_acquired event, then run your delete statement. You can then inspect the captured events...

I think that's about as concise as you're going to get it. As you'll have noticed, string manipulation isn't one of T-SQL's strengths. If you're going to be...

Good. In that case, sounds like you're using different credentials in the package from those you're using in SSMS, or the connection manager specifies a database that doesn't exist.

Is...

How are you running the package - interactively in SSDT/Visual Studio, from a SQL Server Agent job, with dtexec, or something else? Can you ping Server B from the...

Look in the ExecutionLog table in the ReportServer database, and compare the time to run the query with the time to render the report. This will give you an...

Yes, maybe Named Pipes is configured in a non-default way. Try creating an alias that connects with TCP/IP and specify that as the alias in the properties of SQL...

What protocols (Named Pipes, TCP/IP etc) is SQL Server configured to use? You can find this out by looking in SQL Server Configuration Manager.

John

Possibly login failed for the account that runs SQL Server. Does your SQL Server errorlog capture failed logins? If so, have a look and see whether there are...

Difficult to visualise without any table DDL or sample data, but what you want is a snapshot as at the end of last month and the end of the previous...

You asked about formatting the output. What you do in your WHERE clause doesn't make any difference to that. But the WHERE clause you posted doesn't contain any...

Yes, but only to the first server. Find out why the connection to the second server is failing, and your package will then run...

I would strongly advise using the database layer to return the data, and the presentation layer to make it look pretty to the user. If you insist on formatting...

Looks like it's the concatenation part you're struggling with. Work your way through this[/url]. It looks quite daunting, but you should find something there that works for you.

John

Your query mentions at least one column that you didn't tell us about in your original post. Please will you post DDL in the form of a CREATE TABLE...