CASE WHEN @money < 0 THEN '(' + CAST(@money AS varchar(20)) + ')' ELSE CAST(@money AS varchar(20)) END

CRAP!! I went backwards!! Just a sec and I will have a fix ...

DECLARE @var varchar(10), @money money

SET @var = ($111.11)

SET @money = -1* CAST(CASE WHEN LEFT(@var,1) <> '(' THEN @var

...

It can ABSOLUTELY make a difference, depending on the ANSI_PADDING setting for the columns when you created the table. If it is ON and you insert data that has...

See these two posts:

http://stackoverflow.com/questions/10381512/what-this-query-does-to-create-comma-delimited-list-sql-server

http://davidduffett.net/post/5334646215/get-a-comma-separated-list-of-values-in-sql-with-for

Please provide table create script(s) (with indexes if any), sample data to put in said table(s), and expected output from your code.

T.Ashish (8/18/2013)

---

Hi All,

I was trying to use partitioned index for a slow query but I was stopped with following response...

OP is a new user. I already PM'd them back about that. Hopefully they will post up on this thread.

Please provide table create scripts with sample data and expected output and we can write a query to assist. Enable us to help you...

CASE: My favorite 4-letter TSQL word!! 😎

What you seek to do is literally impossible without some identification of the type of date format provided. The reason is that you can have a at least 2...

I would imagine that your query references VIEWS given the naming scheme, meaning we have no idea what is going on in your code. To have much hope of...

Glad we found some improvements. There are still quite a few things to check, but I think though that anything more will be beyond the capabilities of a forum...

Something like this, although again you have provided very limited data.

;WITH a AS (

SELECT agentid, 'Open' AS ExceptCodeDetailName, Detail_Start_Time,

Detail_End_Time, ROW_NUMBER() OVER (order by AgentID, Detail_End_Time, Detail_Start_Time) AS rownum

FROM @testing)

SELECT a1.agentid,...

Given that you are on SQL 2012, here is one solution that uses the new Windowing Functions:

;WITH a AS (

SELECT agentid, 'Open' AS ExceptCodeDetailName,

Detail_End_Time AS Detail_Start_Time,

LEAD(Detail_Start_Time,1,NULL) OVER (order by...