Have a look in BOL under CONVERT to see which...

RTRIM and LTRIM both take a varchar parameter. The float value is implicitly converted to a varchar, then...

Like this?

select

DatePart(hour,Reading_Date) as [hour],

t.Tank_Product ,

convert(Date,Reading_Date,103) as [date],

sum(tr.Sales) as sales,

sum(tr.Price)as price ,

sum(tr.Amount)as amount

INTO #Results

from dbo.Tanks as t

inner join Transactions as tr

on t.Simmons_PanelID = @panelid

and...

SELECT

TimeVC,

FirstColonPosition = CHARINDEX(':',TimeVC,1),

[Hours] = LEFT(TimeVC,CHARINDEX(':',TimeVC,1)-1)

FROM (

SELECT TimeVC = '73:59:59' UNION ALL

SELECT '144:44:59') d

Usman Butt (9/7/2012)

---

ASFSDJG (9/7/2012)

---

If we force clustered index it is display all the columns .

select * from <table_name> with (index (cluster index name>)) where field_id = 2

its gets result.

Execution plan...

Looks fine to me, Tom. It's important that you don't have dupes in the matrix table source (the CROSS JOIN bit), if the two columns returned are the PK's of...

bmahf (9/6/2012)

---

So it turns out that each of these solutions is missing something, it's either the fraction part sometimes comes out incorrect, because it wasn't adjusted as I was doing...

ScottPletcher (9/6/2012)

---

bmahf (9/6/2012)

---

So it turns out that each of these solutions is missing something, it's either the fraction part sometimes comes out incorrect, because it wasn't adjusted as I was...

Heh at least your code works, Phil - even if it doesn't quite match the spec. Mine...

Aarrgghh!! They all fall over given suitable edge cases in the data.

DATEDIFF counts boundaries -...

Phil Parkin (9/6/2012)

---

Yeah you can. Just tried...

Something like this:

SELECT

SubTotalSplit = CASE WHEN OrdMain.SubTotal = 0.01 THEN '= 0.01' ELSE '<> 0.01' END,

sumx = ( (SUM(CASE (LEFT(RIGHT(Rtrim(summary), 12), 5))

WHEN 'EURO/' THEN OrdItem.PriceEach * OrdItem.Quan...

One more:

TimeResult3= CAST(

DATEADD(ns,ABS(DATEPART(ns,btime)-DATEPART(ns,atime)),

DATEADD(ss,ABS(DATEDIFF(ss, aTime, btime)),CAST('1900-01-01 00:00' AS datetime2)))

AS TIME(7))

Nice one, Paul.

Here are two different one-line TSQL solutions:

;With MyCTE (aTime, bTime)

AS

(

SELECT CONVERT(datetime2,'1900-01-01 00:08:00.0000001'), CONVERT(datetime2,'1900-01-01 00:09:18.361')

UNION ALL SELECT '1900-01-01 00:08:00.0000001', '1900-01-01 00:13:50.705'

UNION ALL SELECT '1900-01-01 00:09:18.361', '1900-01-01 03:13:50.7050001'

UNION ALL...

Try declaring @index as int. From BOL: "A sort column can be specified as a name or column alias, or a nonnegative integer representing the position of the name or...