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,...

techmaark (8/30/2014)

---

OLE DB provider "SQLNCLI10" for linked server "REPLLINK_TECHMARK952933815_TEST_CLIEN-672667892_REPUPDSUB2109712029_TEST_SERVE-1760219189" returned message "The transaction manager has disabled its support for remote/network transactions.".

Msg 7391, Level 16, State 2, Line 1

The operation could...

Quick thought, rather than a iterative for loop use foreach table in tables.

😎