Viewing 13 posts - 16 through 28 (of 28 total)
I need the XMLTable function desperately. I tried downloading it from the link provided @beyondrelational. For past 2 days the site seems to be down. Is it possible to post...
September 12, 2018 at 1:54 pm
Thanks guys, but like I said in my original post I already know processing account transaction delta one at a time is slow. Hence this post.
And, I can look into...
August 18, 2015 at 7:15 am
Many thanks guys! Now I know my decision for using XML string to provide input was not haphazard.
So back to my main question then.
If I have the inputs in a...
August 17, 2015 at 1:48 pm
Cadavre (9/6/2011)
Pagan DBA (9/6/2011)
Your log...
September 6, 2011 at 9:59 am
Err, the entire point behind adding the column IS to have auditabel field. Not only does it not help to make it NULL, it should NOT be null.
Sorry, I am...
September 6, 2011 at 9:54 am
I know Timestamp is deprecated. We are using RowVersion.
Besides the point at this time, don't you think? The deprecation of the "syntax" has nothing to do with my problem. Unless...
September 6, 2011 at 9:23 am
I wish it was tooth fairy. Then I could blame someone else.
"Log File Full" is the correct answer to your question. It got full multiple times. Any way I can...
September 6, 2011 at 8:45 am
Err...the code sample I provided was to serve to explain my question. The sporadic results were on my REAL problem where I have several pieces of data EACH versioned and...
August 3, 2011 at 9:01 am
Seriously, I did say I was getting sporadic results. How would I know that if I hadn't tested?
The idea behind the question was to get some insight into SQL and...
August 2, 2011 at 7:29 am
Finally figured it out.
First I thought stopping the SQL Server services would be sufficient. It isn't.
To be clear I was not able to clean out SQL Server 2005 Express on...
June 24, 2011 at 6:52 pm
Already tried. Does not work for me :crying:
June 24, 2011 at 4:00 pm
I don't think my problem is exactly that but it seems to be similar. Here's what I see in my log file.
>> C:\WINNT\system32\cmd.exe /c C:\WINNT\system32\cscript.exe "C:\Program Files\Microsoft SQL Server\XXX\CheckInstances.vbs"
06/24/2011 12:27:49...
June 24, 2011 at 11:46 am
Don't get me wrong. This is a good example of "how to use RANK() and ROW_NUMBER() functions". My problem is why would I do this instead of using DISTINCT?
There is...
July 27, 2010 at 9:47 am
Viewing 13 posts - 16 through 28 (of 28 total)