Quick thought, use cross-tab

😎

Can you post DDL and sample data?

Try pressing CTRL+SHIFT+R (in SSMS) to refresh the intellisense cache...

Quick suggestion

😎

CREATE TABLE tblRoomEquipment( /* Fully descriptive name...

Have a look at these two threads

😎

How to format unformated phone numbers

Digits only

The code shows the behaviour of the same NULL handling

VAL1/ISNULL(VAL2,1)

for all scenarios, simply replace the formula you...

Steve Jones - SSC Editor (12/14/2014)

---

Lynn Pettis (12/13/2014)

---

... Mark one off, 76 days on the calendar to go. 76 days on the calendar to go, 76 days to go, ......

Quick thought, could this be a name resolution issue (DNS/Browser service)?

😎

farrukhhameed786 (12/14/2014)

---

Hi,

I am finding an error while i am dividing value. Some times Val1 is not available and some time Val2 is not available in my case. I need if...

The two ways that one could interpret this, Many2Many and One2Many both imply min=0 and max=(inf.)

😎

R2 => Many to many, min=0,max=(inf)

+-----------+ +----+...

Quick solution based on an inline tally driven calendar table, should get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @DATE_FROM DATETIME = '2013-12-10 04:00:00.000';

DECLARE @DATE_TO DATETIME = '2014-12-10...

Thank you for the question Shiva, straight forward even if the wording could have been more precise;-)

Another interesting thing is that the option "ALLOW UPDATES" is depreciated and has in...

locus (12/13/2014)

---

Hi folks,

We have recently imported a database from Informix into 2008 R2, via linked server.

Everything came across perfectly with the exception of Time Interval columns.

Format 00:00:00, hours minutes seconds.

SQL...

Quick thought, (and in-line with other responses), when opening SSMS do "Run as Administrator"

😎

Quick question, what is the output of this query?

😎

EXEC sp_configure 'show advanced options',1;

RECONFIGURE;

EXEC sp_configure 'Ad Hoc Distributed Queries';

EXEC sp_configure 'show advanced options',0;

RECONFIGURE;

sKreetz! (12/11/2014)

---

Thanks for the quick reply, Eirikur! It worked like a charm and I appreciate the help. As Sean mentioned, users may change their mind and remove line certain line...