with clause in sql server

Question

1.00/5 (2 votes)

See more:

SQL-Server

Can one give me simple example of with clause in sql ?

And Where should we use this ?

Posted 9-Aug-13 3:21am

anurag19289

Add a Solution

Comments

[no name] 9-Aug-13 9:24am

Was the documentation unclear?

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Fredrik Bornander · Answer 1 · 2013-08-09T03:27:00

Solution 1

You can use it to allow dirty reads in a select for example;

SQL

select * from my_table with(nolock) where condition='something'

Hope this helps,
Fredrik

Posted 9-Aug-13 3:27am

Fredrik Bornander

Comments

Manas Bhardwaj 9-Aug-13 9:29am

Yup +5!

Manas Bhardwaj · Answer 2 · 2013-08-09T03:31:00

SQL

WITH Sales_CTE (SalesPersonID, NumberOfOrders)
AS
(
    SELECT SalesPersonID, COUNT(*)
    FROM Sales.SalesOrderHeader
    WHERE SalesPersonID IS NOT NULL
    GROUP BY SalesPersonID
)
SELECT AVG(NumberOfOrders) AS "Average Sales Per Person"
FROM Sales_CTE;
GO

Look further at MSDN:

http://technet.microsoft.com/en-us/library/ms175972.aspx[^]

with clause in sql server

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

with clause in sql server

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us