Where did you get the conclusion that the answer should be 52.8? Can you give us sample data?

What is the data type of 'columnname'?

casting the sum as a float is no good if it was not one before. The precision has been lost before the conversion

Its possible that smaller businesses developing new systems from scratch are thinking cloud first, or starting to.

But I haven't seen any sort of groundswell to move existing database implementations to...

As others have said, nice question to demonstrate a fundamental point, and the possible answers don't give away the correct one which is good (tougher to just guess).

However, it could...

The convert you are using is only showing the hours, minutes and seconds, and the answer you want is 1 day, 1 hour, 42 minutes, and 46 seconds

You can try...

Phil Parkin (10/13/2013)

---

Well, I think we are drifting into a grey semantic area here.

SSIS natively provides...

Is this what you want? You may want to add in a case check

ISNULL([Animal]) ? "" : ( [Animal] == 'Cat' ? 'Dog' : [Animal])

You can still cross tab or pivot, but you will need to use dynamic SQL.

Something like:

SELECT e.EID FROM #EventLog e

INNER JOIN #LD l

ON e.SourceID = l.TranId

WHERE l.TranID = 1234

AND e.SourceType = 3004

UNION ALL

SELECT e.EID FROM #EventLog e

INNER JOIN #LD l

ON e.SourceID = l.LoanId

WHERE l.TranId...

Yes, there is a hierarchical relationship within your groups, and it is not in...

maybe you were missing the order by? All the solutions seem workable to me.

Try:

WITH CCSGLinks AS (

SELECT [BSP_LOB_GRP],

[BSP_LOB_CD],

[BSP_LOB_GRP_TYPE_CD]

CASE WHEN BSP_LOB_GRP IN ('LOB Group','Site Group','Sales Group') THEN 'CCSG Group' ELSE BSP_LOB_GRP END LinkedGroup

)

select *

from USER_PRFL p

join CCSGLinks gl on gl.LinkedGroup = p.[User_Group] or...

vigneshlagoons 51204 (10/10/2013)

---

Hi Nevyn,

Site Group, Sales Group, LOB Group and CCSG Group are values present in BSP_LOB_GRP column.

If a user is logged in as a CCSG Group members he...

This query fetches value of CCSG Group, but there are some more groups present in BSP_LOB_GRP column like (Site Group, Sales Group, LOB Group) and these group should belong to...

ali.m.habib (10/10/2013)

---

I want to select top 1 value either null or value from this query

select top 1 column5 from table2 where table2.column1ID = 5

if the whole value of this...