That's the MS standard. 😀

That's why I suggest...

Having to use dbms_output.put_line(); is one of the many reasons that I hate Oracle.

T-SQL has a simpler way to work as stated before. If you need help on the "do...

jasona.work (6/7/2016)

Nah. I was sorely tempted to put together a Powershell script...

Was I too late for April fools' day?

This is what happens when you trust a forum to answer questions that you should answer on your own.

I could have given a...

Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.

Try this:

SELECT sys.fn_get_folder(path, 1)

You don't have to take the exams in a particular order, as long as they're from the MCSA certification. I would suggest that you start with the one you feel...

So you're moving away from Control-M.

If I remember correctly, Control-M tasks are very similar to a cmdexec step on SQL Server Agent. You might need to check that the connections...

Why call a job from an automation tool from another automation tool which is more restricted? Seems like you just want to create additional problems.

You could use the STUFF function or even the SUBSTRING.

Here's an example using STUFF with different combinations.

SELECT Field1,Field2,Field3,

STUFF( CONVERT(CHAR(20), ISNULL(CASE WHEN Field1 > 0 THEN ',1'...

T-1000

I don't get that error with a correction on your code.

--Create sample data

CREATE TABLE TableA( MyDate date, OtherDate date);

CREATE TABLE TableB( xDate date);

INSERT INTO TableA(OtherDate) VALUES(GETDATE()), (GETDATE()-1), (GETDATE() - 2);

INSERT...

The display can be changed in the front-end by the web developers. They might be using float in the front end, but it doesn't mean that the values need to...

Weekend