Agree!

i don't see how this exercise have any concern with the answer. :unsure:

what a pitiful QOTD (¬.¬) i lost my 10-row good questions.

Next time advice in which SSMS you tested it.

I got script B twice in

Microsoft SQL Server 2008 R2 (SP2)...

¿Which should be the content of the file"Hostname.txt"?

Or write an example of the file body.

Thanks

Very interesting post, i enjoy it :w00t:

Btw, is there any kind of method like this to track DML without using CDC or Triggers??

Thanks, Regards

Nice QotD Steve!, the next question do it with clause "ANY"

😛

with sales (Customer, Salesyear, Complete, Amount) as (

select 1 ,'2013', 1 , 100 union

select ...

It's not a parsing error, if you type the statement outside the try/catch you will figure it's a normal execution error, even if you execute it within a Exec('') you...

:angry:

That was sad! -7

Very nice QOTD

Was good the explanation about semicolons 😀

Update Dbo.QOTDTABLE Set ANSWER='ALL' WHERE QOTDTABLE.Date BETWEEN ('20141015','20141016')

:w00t::w00t::w00t:

+1

:w00t:

Hello everybody

My apologize for this "mistake" over the QOTD, i really don't know what happened since the original query was:

CREATE PROCEDURE my_sp AS

SELECT columns FROM my_table

My intention was not...

ahh by the way, someone told me that first query might return unexpected results, ¿how could this be possible?

Nice one!

Indeed i guess that windows function would be better but like you say, usually we create a hyper mega cannon based on electron lasser to destroy an ant :w00t:

So...

I forget something, is there any way to use windows functions on this example?

thanks 😀