Back in the mid 80's I was going to school at DeVry in Kansas City.  We had to submit our COBOL programs to compile during our one hour lab time....

Here is what I came up with:

SELECT ISNULL(ac.code, b1.code) AS code, a2.aname, b1.bname, ac.cname

FROM (SELECT a.code, a.aname, c.cname, ROW_NUMBER() OVER (Partition BY a.aname ORDER BY a.code, a.aname) AS RNO

FROM @a...

A baseball bat would work the same. See movie 'Office Space' for an example. 🙂

At my prior job we had the SSIS packages stored on network drives. I was able to use the tool Ultra Edit to search across these folders for specific...

Here is some SQL I've used to search SSIS packages to see if a field or table is used in the package. This seems to work for the size...

Steve Jones - SSC Editor (6/29/2016)

---

below86 (6/29/2016)

---

I had my SSC account tied to my work email, and the password was saved by IE. So when I lost my job...

dave.farmer (10/14/2016)

---

At the risk of outing myself as a pale imitation of a database professional, I work to live, not the other way around.

Apart from being on call (which now...

Seems more 'down to earth' than doing stuff in the cloud.:-)

Just a quick update, I got a new job and I've been at it for over 3 weeks now. Things are going good, just need to learn how they...

I was also let go in April, but I'm still looking. I have been hesitant to talk to any recruiters so far, had a bad experience with one back...

Iwas Bornready (6/29/2016)

---

I'm assuming you're joking. Though they are supposed to be unique, working in the health industry we find...

I had my SSC account tied to my work email, and the password was saved by IE. So when I lost my job and couldn't remember the password but...

Lynn Pettis (6/3/2016)

---

Steve Jones - SSC Editor (6/3/2016)

---

We can be pedantic if we want. However, a batch consists of 1 or more statements. The option notes that the previous statement...

martin.whitton (6/3/2016)

---

Anyone who doesn't terminate SQL statements with a semicolon should note the following (from https://msdn.microsoft.com/en-us/library/ms177563%28v=sql.110%29.aspx ):

Transact-SQL statement terminator.Although the semicolon is not required for most statements in this version...

The person who set it up works in HR of the company I applied to. I'm assuming she will be the one I will be talking to.(I know it...