Just keep in mind that your client must have MS Office installed for that to work. 🙂

But that could work.

Now to the experts: Is a CLR stored procedure a bad...

Wonderful advices! Thank you.

Some day I'll put them to good use (not a DBA yet) but I'm gathering knowledge to become one.

Oh, and I'd really love to see zombies ruling...

pelusodm (9/26/2011)

---

I would like to create a stored procedure that calls the DOS batch file. However, I do not know what the sql coding would be for the script....

The only circumstances that I'll use dynamic sql is in those that there's no other way around it.

Example:

SELECT * FROM OPENROWSET(BULK @FileName, SINGLE_CLOB) AS Temp;

Because the OPENROWSET command will not...

Ninja's_RGR'us (9/26/2011)

---

codebyo (9/26/2011)

---

Ninja's_RGR'us (9/26/2011)I've not tested that way either. What I do is save the output (only errors) and if anything is inserted into the logging table then I...

Ninja's_RGR'us (9/26/2011)I've not tested that way either. What I do is save the output (only errors) and if anything is inserted into the logging table then I assume something...

Isn't it possible that at the end of the "DBCC CHECKDB" step you would choose "On failure action" as "Quit the job reporting failure" and all of the next steps...

Great question.

The precedence of operators, in that case, will make all the difference.

Since it's math, if we use parenthesis, we'll get a different result as expected.

SELECT '2' + '3' *...

Also you could use the "yyyymmdd" format without any "-" or "/" characters and they'll be accepted with any settings. It's a safe bet.

Best regards,

SQL Kiwi (9/23/2011)Adam (Machanic) would no doubt want me to encourage you to share a link to SQLblog instead (traffic = advertising = pays the hosting bills) but I understand...

I have been following your blog for some time now but I hadn't found that article before. I have much to learn and I appreciate those links.

Can I...

Amazing question. Thank you.

Now I must confess that I got it right completely by luck but with a trail of thought that TRUNCATE TABLE is minimally logged and doesn't affect...

Thank you for such an amazing question, Paul.

I got it right because I always remember reading that the "top (outer) input" is read first and then it goes look for...

SQL Kiwi (9/19/2011)

---

This is one way:

SELECT

id =

CASE

WHEN GROUPING(e.id) = 1 THEN 'Total'

ELSE CONVERT(VARCHAR(12), e.id)

END,

...

Got it wrong.

I thought that there would be an error because the StudentId column has the alias "StudentNumber" inside the subquery and in line 25 it's being declared as StudentId...