erikd (4/15/2013)

---

Sean Lange (4/15/2013)

---

ISAPLHA?? What would you be testing for? Not exactly sure what "woogy symbols"...

Sure it does. It is all...

Lynn Pettis (4/15/2013)

---

Sean Lange (4/15/2013)

---

erikd (4/15/2013)

---

Hi,

Does anyone have a list of all the IS (date/numeric) type syntax available? I've been trying to find a resource that just lists them all...

ISAPLHA?? What would you be testing for? Not exactly sure what "woogy symbols" are. 😉

Step 1: Determine the severity of the issue.

Step 2a: If severity is small, fix the issue.

Step 2b: If severity is major, lock the door, take my phone off the hook...

Oh yeah ISNULL too.

erikd (4/15/2013)

---

Hi,

Does anyone have a list of all the IS (date/numeric) type syntax available? I've been trying to find a resource that just lists them all out, but I guess...

Mike Stuart (4/15/2013)

---

The CEO of our company wants to know what all the different departments within IT (server operations, network operations, DBAs, etc.) do during a "production incident" to...

maxlezious (4/15/2013)

---

Sean i totally agree with what you said and apologies i didnt post the data in the correct format. In future ill make sure I post all the required...

Rob-350472 (4/15/2013)

---

Indeed, quite why I didn't just do something like this:

SELECT

t.ID,

t.Title,

(SELECT count(l.log_id) FROM #logs l WHERE l.id = t.id) as AllTime,

(SELECT count(l.log_id) FROM #logs l WHERE l.id = t.id and...

parikiti (4/15/2013)

---

sean i really do get what you mean...let me try to get you more info...

basically the customer information in the customersA table on any given day can have multiple...

Rob-350472 (4/15/2013)

---

What I'm trying to do is something I've not done before (perhaps this is why!), say you've created a temp table - a bit like my example - but...

We know you are new around here and we really do want to help.

The problem is that we can't use your data. Here is what you posted.

Sample Data from column...

Rob-350472 (4/15/2013)

---

I figured somebody might know the answer from the 'double join' side of things...

Here's a couple of test tables with inserts:

It still works, as in it doesn't throw an...

adonetok (4/15/2013)

---

In my one asp.net app, I created a connection string to ServerA and then created a linked server from ServerA to ServerB. It working fine.

But, new boss said that...