kalpit_yellow (4/10/2013)

---

Thanks for the reply...actually i have following query and i want actual stored proc name instead of whole procudere on Last_executed_SQL column...

SELECT ec.session_id, connect_time,s2.[text] as Last_Executed_SQL

...

What will consume the results of the query? Just about any reporting front-end will have the facility to pivot the results to the format you want. This is...

Also try the Sql Server Configuration Manager and see if any Aliases were created.

There is no need to hard-code each payment type in a pivot query. Dynamic SQL can take care of that.

The CASE statement is used for conditional substitution of values, not formulae.

Perhaps the logic can be refactored into the WHERE clause?

Use UNPIVOT to turn each PAYMENT_TYPE into its own column. See the following link.

Then your calculation should be easy 🙂

Try using DATEDIFF

http://msdn.microsoft.com/en-nz/library/ms189794%28v=sql.100%29.aspx

In conjunction with ROUND

http://msdn.microsoft.com/en-us/library/ms175003%28v=sql.100%29.aspx

For example:

declare @work_order_end_date date

declare @work_order_start_date date

set @work_order_start_date = '2012-12-03'

set @work_order_end_date = '2013-05-31'

select round(datediff(d, @work_order_start_date, @work_order_end_date) / 30.0, 0)

Use SQL Server Profiler to run a trace on your database. When creating the trace, tick show all events, and go under the Performance heading to choose a showplan...

This is probably because of the data types of your numerical columns. Please post DDL statements for all the tables referenced in the query.

Also take a look at the...

From what I understand of your question, a simple UNION ALL will get you what you need. The example answer assumes that both databases are in the same server....

I found this article a helpful introduction to what Wait States are, how to check them, and most importantly how to interpret the results 🙂

http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/[/url]

Can you please reproduce the problem and post your table creation, data, and query scripts in this format[/url]?

Interesting. Looks like you hit a similar problem to this:

http://www.glorf.it/blog/2008/05/16/sql-talk/sql-server-is-not-aware-of-nondeterministic-functions

In query #1, the non-deterministic function in the subquery is applied after the join (also note the "No...

You can use the following SQL to compose the comma-delimited string, without needed to trim the trailing comma at the end:

SELECT @MyStatusList = ISNULL(@MyStatusList + ',', '') + StatusDesc FROM...

I would say "Yes" to all three especially with Reporting Services.