Hi, this is a bug

https://connect.microsoft.com/SQLServer/feedback/details/690839/outplut-clause-into-table-with-identity-ignores-set-identity-insert-setting

Is all you have done replaced the CURSOR...

farax_x (6/14/2012)

---

Tnx for your replies

Dave Ballantyne (6/14/2012)

---

Something like this ?

Untested

with ctenum

as

(

Select top(100) Row_number() over (order by (select null)) as rown

from sys.columns

)

SELECT TOP...

Something like this ?

Untested

with ctenum

as

(

Select top(100) Row_number() over (order by (select null)) as rown

from sys.columns

)

SELECT TOP 5 *

FROM dbo.tblLottery

join ctenum

on...

Have you tried EncryptByCert ?

http://technet.microsoft.com/en-us/library/ms188061

If you use MERGE , you can do this.

http://sqlblog.com/blogs/rob_farley/archive/2012/06/12/merge-gives-better-output-options.aspx

Thats is not the point , profiler will introduce locking that can slow down a production server. By moving it to another server you have made it even worse.

http://weblogs.sqlteam.com/dang/archive/2007/12/16/Avoid-Causing-Problems-with-Profiler.aspx

I dont think this is particularly worrying , more worrying is that are running profiler live. Dont do this, use server side tracing . Profiler will bork the...

Hi,

You need to use the GROUP BY clause

Select SalesPerson , count(*)

from Sales

Group by SalesPerson

A bit of a vague question , but i would recommend any book by Itzik Ben-Gan.

Start out with this one.

http://www.amazon.co.uk/Microsoft-Server-T-SQL-Fundamentals-PRO-Developer/dp/0735626014

Show us the code for how far you got and we may be able to provide pointers to take you the rest of the way

A nice piece of homework....

So the way to solve this would be to group by picking the min and max order and aggregating (summing )bookvalue and accvalue. Then...

All done, it was a tough rider to get together but we've had worse demands 🙂

You...

Tony Rogerson has been playing a lot with commodity SSD kit recently

http://sqlblogcasts.com/blogs/tonyrogerson/default.aspx

Hi all,

havent been around 'the thread' for a while, and only dipped in and out of SSC, been a bit busy :ermm:

Im running a lunch time user group in London...