😀

ChrisM@Work (9/28/2012)

---

dwain.c (9/27/2012)

---

Phil,

I think this is a pretty snappy query too.

;WITH Tally (n) AS (

SELECT TOP (SELECT 1+MAX(DATEDIFF(day, StartDate, EndDate)) FROM #RoomDates)

...

This article by Jeff Moden gives you arguably the best way to approach the running totals problem:

http://www.sqlservercentral.com/articles/T-SQL/68467/

Jeff Moden (9/28/2012)

---

Most of you know me. If I thought a Tally Table would be the best thing for this problem, I'd be on it like white on rice....

only4mithunc (9/30/2012)

---

Thanks dwain.c,

I'm getting the answer with that code. I'm just trying to see if I can rewrite this some way so that I don't have to hard code my...

coronaride (9/27/2012)

---

Well, that's the problem. Like I mentioned, the users are able to build their own expressions through our UI and keep any number of them that they want. I...

Jeff Moden (1/16/2011)

---

Sachin Nandanwar (1/16/2011)

---

Well I just stumbled upon this article.I tried to do it using quirky update method and seems to be working but haven't tested it on a...

The next thing I would try is to SELECT the problematic SQL out to the Results pane in SSMS, copy/paste it into an Execute window, run it there and see...

How are you executing the SQL?

1. EXEC

2. sp_executesql

I've used #2 with VARCHAR(MAX) strings (that contained > 8000 chars) before with no problem.

I confess I haven't thoroughly read this entire thread but I don't think this approach was covered.

DECLARE @Test NUMERIC(5,4) = 1.55

SELECT REPLACE(REVERSE(0.+CAST(REVERSE(@Test + 0.) AS FLOAT)) COLLATE Latin1_General_BIN, '.', '')

I...

Are you looking for something like this?

;WITH XMLParser AS (

select x.[desc].value('.','varchar (230)') as [desc]

, y.[desc].value('(./String)[1]','varchar (230)') as [path]

...

Here's another, relatively straightforward approach:

;WITH ApplicationsGrouped AS (

SELECT ComputerName

,Applications=STUFF((

...

Another way is like this (a computed column):

IF object_id('TempDB..#tTemp1') IS NOT NULL

DROP TABLE #tTemp1

CREATE TABLE #tTemp1(ID int, Name varchar(20)

,Comment AS ('The city name is ' +...

OMG! :w00t:

I must have read this article 5 times at least and I never could quite get a grip on it.

Finally, I've been able to apply it to a real...

Phil,

I think this is a pretty snappy query too.

;WITH Tally (n) AS (

SELECT TOP (SELECT 1+MAX(DATEDIFF(day, StartDate, EndDate)) FROM #RoomDates)

...

If you ever get around to having one...