Nope, you gonna have to use EXPLICIT. It was confusing for me as well. Once the lights get turned on, it became quite easy. It's extremely powerfull! Have a look at the exqamples in there and try change them to suite. If you get stuck, shout 🙂 Cheers, Crispin
2003-06-17
I came across a sp named sp_eventlog. It is undocumented. It may be what I am looking for but I can't find what parameters I need to pass to it. Does anyone know if this sp will accomplish? Thanks, John
2003-06-16
John - i'm used to using derived tables in my selects - bad habit i've picked up 🙂 thanks for reminding me
2003-06-16
2 reads
yeah, I saw that too. I was just looking for the same inherited right that sa has to execute. Thanks for the thought. John Zacharkan
2003-06-10
Hello Todd, another thought that came to my mind is, that - assuming a 'good' programming - all stuff that is needed to built the new db should be placed in one single file. As Jay suggested, if possible you should post some code here. Cheers, Frank
2003-06-10
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-09
if you have a unique key in the results then yes USE PUBS SELECT ( SELECT COUNT(*) FROM Titles T2 WHERE T1.Title_id <= T2.Title_id) As RowNo , * FROM Titles T1 ORDER BY 1 but try this on a bigger table , and it will probably kill your server .. stick to the temporary table […]
2003-06-06
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-06
2003-06-06
2 reads
2003-06-05
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers