Here is an alternative method without recursion, uses Tally table type looping instead. The code uses Chris's sample data to produce comparable output. It is simplified and limited to that...

TomThomson (8/30/2014)

---

Eirikur Eiriksson (8/30/2014)

---

sharonsql2013 (8/30/2014)

---

I am trying to do an average with the following case statement

Select

AVG(Case when TotalHours < = 60 And TotalHours > 0 then TotalHours else...

sharonsql2013 (8/30/2014)

---

I am trying to do an average with the following case statement

Select

AVG(Case when TotalHours < = 60 And TotalHours > 0 then TotalHours else 0 end)AVGWithin60

AVG(Case when...

Just in case you missed this from the previous instance of the question, modified to return blank if no HardDrink

😎

USE tempdb;

GO

SET NOCOUNT ON;

CREATE TABLE #TEMP (T_ID INT IDENTITY(1,1),UserName varchar(20),Drink varchar(20),Value...

Shadab Shah (8/29/2014)

---

Hi Experts,

There would be a better solution then , the one mention above by me.

If some body has it would be great to know. Just to improve on...

Can you ping the servers in both directions from each other using the server names, not the ip address (oops that sounds twisted:-))?

😎

The Menu (translated to SSC'lect)

Post and Spam

Post,...

Greg Edwards-268690 (8/30/2014)

---

Jeff Moden (8/29/2014)

---

Ok... the dust bunnies are in an uproar and the hunt is on for "lost sock" as the only possible source of the leak for the...

First thought and if I remember correctly, set the NetworkDtcAccessTip (Transaction Internet Protocol (TIP)) to 1. Do check on technet though as my...

polkadot (8/30/2014)

---

first, I'm going to tell you that there's a system admin guy on my team that seems to come up with junk statements and makes dubious claims. ...

Quick thought, have a look at this page Enable Network Access Securely for MS DTC, guess this is your problem.

😎

Here is a quick "set based loop" method using an inline Tally table to count the hours.

😎

USE tempdb;

GO

DECLARE @TEST_DATA TABLE

(

TEST_DATA_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY...

Lynn Pettis (8/30/2014)

---

I am jaded. I just read a reopened old thread by one of my favorite people. How, I ask you, can you work with SQL Server...

Quick thought, use a combination of replace and convert with the 110 format directive

😎

USE tempdb;

GO

DECLARE @MMDDYY VARCHAR(20) = '01 20 1950'

SELECT CONVERT(DATETIME,REPLACE(@MMDDYY,CHAR(32),CHAR(45)),110)

Result

1950-01-20 00:00:00.000

He he,...