S3

Technical Article

RE: need help with query

  • Reply

sorry, I cannot think of any easy way with a subquery,  what you have is a mess ...lolI have never seen a good way to compare details from different rows and different columns with a subquery.  I hope your tables are not that large cuz it is kludge code you are going to needGood luck. tal

2004-06-11

Technical Article

RE: DORMANT Status

  • Reply

 Same as Sleeping, except Dormant also indicates that the SPID has been reset after completing an RPC event. The reset cleans up resources used during the RPC event. This is a normal state and the SPID is available and waiting to execute further commands.   bye

You rated this post out of 5. Change rating

2004-05-14

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers