You've posted in the SQL Server 2008 forum, so I assume that's what you're using. If so, search this site (or elsewhere) for Running Totals. If you're on...

Once you've got the views created, the rest is easy. All you need to do is grant SELECT on the views to all users, and revoke SELECT on the...

The problem here appears to be that you've got too many (more than one, that is) different pieces of information stored in each value of nine_data. Such denormalisation may...

It gives info for all active sessions. If you have the patience, you can look at the stored procedure definition and try to find the part that retrieves tempdb...

Have you looked at sp_whoisactive?

John

You can't build a table name from variables. You'd need to use dynamic SQL, which I don't think you can use in a function, so you'd need to change...

One alternative is to use a calendar table, with a row for each date and an IsWorkingDay column that you can use to count three working days forward. If...

Steve

DDL, code and execution plans would indeed be helpful, please.

When you do a UNION, the result sets all have to be sorted together to eliminate duplicates, so it does seem...

Do you get the same problem if you choose a matrix style other than Forest?

John

What command are you using to do the restore, or are you using the GUI? If you're using the GUI, please use the Script button on the Restore Database...

Damian

Just right-click on the job in SSMS, choose Script Job As and use one of the options to generate the script.

John

From what we know, we can't assume that Product is a table and not a view. What does this query return?SELECT

SCHEMA_NAME(schema_id) + '.' + name AS ObjectName

,'View' AS ObjectType

FROM...

Anandkumar-SQL_Developer (12/15/2016)

---

Dear Shekhu ,

Thank you very much for your valuable time . your code is working well. it showing clustered & nonclustered index only...

So you want the CREATE INDEX statement for the given index? You could right-click on the index in SSMS and choose Script Index As. If you want it...

Have you tried sp_helpindex?

John