popq79 34287 (1/23/2013)

---

Hi All

Can someone help me how to select the row with min(E_DATE+E_Time) for each PATIID from the below table?

PATID NAME A_DATE E_DATE E_TIME...

What are trying to gain there? The...

Having never heard of solar winds on a server a quick google search suggests that this is free ftp software? If that is the case it has absolutely no business...

I see you are pretty new around here. Can you please take a look at the first link in my signature for best practices when posting questions?

Also, if at all...

Sean Pearce (1/23/2013)

---

Sean Lange (1/22/2013)

---

newdba_sql (1/22/2013)

---

Adding this logic will check the time and if it is not 7AM, it will keep waiting until it is 7Am. How can I add...

ScottPletcher (1/22/2013)

---

Sean Lange (1/22/2013)

---

ScottPletcher (1/22/2013)

---

Sean Lange (1/22/2013)

---

GilaMonster (1/22/2013)

---

Sean Lange (1/22/2013)

---

ScottPletcher (1/22/2013)

---

DiverKas (1/22/2013)

---

1) Do NOT let your C#/VB/ASP/Pascal guys design the database.

2) Do NOT let your DBA's design the database.

3) Hire...

ScottPletcher (1/22/2013)

---

Sean Lange (1/22/2013)

---

GilaMonster (1/22/2013)

---

Sean Lange (1/22/2013)

---

ScottPletcher (1/22/2013)

---

DiverKas (1/22/2013)

---

1) Do NOT let your C#/VB/ASP/Pascal guys design the database.

2) Do NOT let your DBA's design the database.

3) Hire a Data Architect.

Just...

GilaMonster (1/22/2013)

---

Sean Lange (1/22/2013)

---

ScottPletcher (1/22/2013)

---

DiverKas (1/22/2013)

---

1) Do NOT let your C#/VB/ASP/Pascal guys design the database.

2) Do NOT let your DBA's design the database.

3) Hire a Data Architect.

Just saying. The...

newdba_sql (1/22/2013)

---

Adding this logic will check the time and if it is not 7AM, it will keep waiting until it is 7Am. How can I add a time check every...

You really should post your replies in your thread. That way other people who may want the same thing can benefit from the conversation.

davdam8 (1/22/2013)

---

Hi geniuses,

It is possible to have a 'GROUP BY' inside a CASE Statement? In order to Sum my values properly?

What I got so far:

CASE WHEN KTVID = '12345' AND...

Sounds like something is wrong with the design there somewhere...maybe you can add a first step to the job with WAITFOR sql command? This can be problematic if there are...

You're welcome. I will cross my fingers for you as you test in production. Post back and let me know how it goes if you get the chance.

ScottPletcher (1/22/2013)

---

DiverKas (1/22/2013)

---

1) Do NOT let your C#/VB/ASP/Pascal guys design the database.

2) Do NOT let your DBA's design the database.

3) Hire a Data Architect.

Just saying. The first 2 groups...

Harry Drenth (1/22/2013)

---

Does anyone knows a way to handle errors in eg. stored procedure, function or trigger in a generic way?

Would it be possible to implement this once. I understand...