BenWard

Forum Replies Created

Viewing 15 posts - 121 through 135 (of 264 total)

RE: Need to consolidate data from Multiple EXECs

Personally (if at all possible, I don't know the systems you are working with) I would look at making the stored procedure Rpt_ItemWhereUsedSpTest output what you want in the first...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 1, 2011 at 7:43 am

#1401609
RE: T-SQL Multiplcation

Tom,
Allow me to help you out a little here, you forgot your xml tags...
<?xml version="1.0"?>
<Tom>
<Action="Rant">
<Subject="ProgrammingFoolishness">
L' Eomot Inversé (10/18/2011)
Good interesting question.
Just shows...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 18, 2011 at 4:24 am

#1395774
RE: T-SQL Multiplcation

I guessed it would be different due to some kind of precision thing - I now understand why that is the case.
Not sure where this will come in handy for...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 18, 2011 at 3:25 am

#1395752
RE: Very confused... Why did a log backup put my DB in recovery?

Cheers 🙂
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 12, 2011 at 4:20 am

#1393333
RE: Very confused... Why did a log backup put my DB in recovery?

Wrey! that worked thanks 🙂
I'm still confused as to why doing a BACKUP makes it immeidiately ask to be RESTOREd?!?
strange. I think I need to do some reading on the...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 12, 2011 at 4:15 am

#1393331
RE: Very confused... Why did a log backup put my DB in recovery?

ok thanks I shall have to read up on tail logs, so how do I tell it to stop recovering?
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 12, 2011 at 3:30 am

#1393318
RE: exceptional logic

Chris Umbaugh (10/11/2011)
I also had never heard of EXCEPT and INTERSECT and learned a lot from this QOD. I even had an opportunity to employ INTERSECT in a QA query...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 12, 2011 at 1:48 am

#1393274
RE: exceptional logic

Sudhir Dwivedi (10/11/2011)
Very Nice Question.
And Yes, one should always understand the precedence rules. Using parentheses is good way to prevent any sort of possible risks.
Best Regards,
Sudhir
Absolutely. I would normally include...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 11, 2011 at 9:34 am

#1392959
RE: exceptional logic

wware (10/11/2011)
I honestly never heard of EXCEPT or INTERSECT before either. Seeing them today for the first time, they work exactly as I'd expect them to. I can...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 11, 2011 at 7:55 am

#1392862
RE: exceptional logic

I'm very glad to see that so far no-one has answered '3' 😀
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 11, 2011 at 7:02 am

#1392826
RE: exceptional logic

george sibbald (10/11/2011)
nice question, strictly speaking shouldn't it be union all?
thanks.
as for union all, it makes no odds for the purpose of this example or if you're trying to get...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 11, 2011 at 6:56 am

#1392821
RE: exceptional logic

paul s-306273 (10/11/2011)
Good question Ben - I'd not come across 'except' before.
thanks, I hadnt either. I discovered it during a brain fart moment - I couldn't workout how to do...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 11, 2011 at 5:14 am

#1392765
RE: exceptional logic

vk-kirov - thanks for your excellent explanation - much better than mine 🙂
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 11, 2011 at 2:47 am

#1392726
RE: exceptional logic

Carlo Romagnano (10/11/2011)
palotaiarpad (10/11/2011)
That was a nice question. But in production code i would have used paraenthesis for better readability. 😛
Me, too! 😀
LOL that would mean that my colleagues could...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 11, 2011 at 2:10 am

#1392702
RE: Big Gaps

Steve Jones - SSC Editor (9/23/2011)
This is why I think everyone should have to do C that writes code. Not that sysadmins necessarily need to, but devs/DBAs do. I think...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

September 23, 2011 at 9:47 am

#1385870

Viewing 15 posts - 121 through 135 (of 264 total)