Hi Mike

Look for DMVs "sys.dm_exec_sessions" and "sys.dm_exec_requests"

Greets

Flo

You can sort by NEWID()...

DECLARE @xml XML

SELECT @xml = '

1

2

3

4

5

6

7

'

SELECT TOP(3)

T.C.value('(text())[1]', 'int')

FROM @xml.nodes('root/item') T(C)

ORDER BY NEWID()

Greets

Flo

SQL Server 2008 Enterprise...

APARNA (5/17/2009)

---

If I sort by InvetsorName tag2 should be the first tag, if I sort by order1 amount tag2 shoule be first, if I sort by order2 amount...

Hi

As Barry already wrote, accessing external resources like a HTTP post/request.

2) What are things that needs to be taken care...

Hi Bob

I would say, it depends on the data and the requirements.

ROW_NUMBER() is always incremental. RANK() and DENSE_RANK() increment by...

Why? :unsure:

I use this since about 5 years. Long time before I joined SSC 🙂

Thanks Jeff!

It's not a big deal but if I get one Dollar for every time I showed somebody to remove a cursor I would be a rich man...

Best wishes

Flo

Hi John

Didn't compare the time-stamps. Just thought that Lowell's post might be the answer (I didn't validate it). It was an information for you and others.

Greets

Flo

Hi

Don't try to concatenate a complete UPDATE statement with all values. Use the SqlParameter objects instead.

Greets

Flo

No cross-posts. Lowell has already answered here:

http://www.sqlservercentral.com/Forums/Topic718578-149-1.aspx

Hi

Your Tally table does not contain any numbers 😉

Put this code above your URL-split:

INSERT INTO dbo.Tally

SELECT TOP (11000)

ROW_NUMBER()...

Hey Paul

Nice new avatar! Is it Raumati Beach?

Hi ohio_bear

Funny requirement 😀

First use a modified version of the split function above to get the slash positions into a table. After that you can use a PARTITION row-number or...

Hi

As first, thanks for the very good sample data and required result description!

You can use a CASE block to get the specified column value:

SELECT

...