windows_mss (11/6/2015)

---

Thanks Sean,

Business of the output is to find the number of request per LocID, avg time taken per request, min time taken & max time taken.

Combination of 1 PS...

Here is your data turned into something consumable.

if OBJECT_ID('tempdb..#Something') is not null

drop table #Something

create table #Something

(

LogID int

, LocID int

, ClientCert varchar(20)

, MsgType varchar(10)

, MsgOut char(2)

, MessageTimeStamp datetime

, System char(3)

)

insert #Something

select...

windows_mss (11/6/2015)

---

Thanks Sean,

The result will be looks like as below,

LocIDClientCertificationMsgType Time Taken

NOT SPECIFIED QRY_T12 10 Sec

759NOT SPECIFIED ...

Luis Cazares (11/6/2015)

---

Sean Lange (11/6/2015)

---

Ed Wagner (11/6/2015)

---

Brandie Tarvin (11/6/2015)

---

Greg Edwards-268690 (11/6/2015)

---

Eirikur Eiriksson (11/6/2015)

---

On the current topic, a very favorite question: When do you use the function "WhatTimeIsIt()"?

Three options given

1) To...

windows_mss (11/6/2015)

---

Hi

I have the table with the similar set of records which mentioned below, i'm little bit confused to find the time difference between two rows of record. By Using...

Ed Wagner (11/6/2015)

---

Brandie Tarvin (11/6/2015)

---

Greg Edwards-268690 (11/6/2015)

---

Eirikur Eiriksson (11/6/2015)

---

On the current topic, a very favorite question: When do you use the function "WhatTimeIsIt()"?

Three options given

1) To get the current time...

Hi and welcome to the forums! Kudos on wanting to get rid of this menace of code. You have a cursor and nested inside that cursor are two while loops....

mar.ko (11/6/2015)

---

We are running a stored proc from Pentaho's job scheduler on an hourly basis.

Strangely, about every 3 days, the job bombs on this error:

Execute SQL script.0 - Invalid object...

xsevensinzx (11/6/2015)

---

Lynn Pettis (11/6/2015)

---

xsevensinzx (11/6/2015)

---

Brandie Tarvin (11/6/2015)

---

xsevensinzx (11/6/2015)

---

Jeff Moden (11/5/2015)

---

Precisely. I couldn't have said it better myself. It's a bit like interviewing a mechanic. If they can't...

Luis Cazares (11/6/2015)

---

Sean Lange (11/6/2015)

---

Luis Cazares (11/6/2015)

---

Rich Mechaber (11/6/2015)

---

Aaron Bertrand had a nice blog about this: scroll down for "Pop Quiz" and see if you still think DATEPART abbreviations are...

Unless they meant to type the full name and fat fingered the a and turned...

Luis Cazares (11/6/2015)

---

2 letter abbreviations are...

Good question Steve.

Count me as being in the camp for long hand. I am entirely too scatter brained to remember all the abbreviations. Even the common ones make me stop...

That is an excellent try but it is not quite what they are after. They want groups of contiguous dates...

xsevensinzx (11/5/2015)

---

Ed Wagner (11/5/2015)

---

Sean Lange (11/5/2015)

---

xsevensinzx (11/4/2015)

---

Jeff Moden (11/4/2015)

---

Brandie Tarvin (11/4/2015)

---

Jeff Moden (11/3/2015)

---

Man o man... yet another self-proclaimed DBA bites the dust in the interview process as has another self-proclaimed...