Comments by Member 11137292

Member 11137292 22-Mar-17 3:32am View

Have you checked the windows eventlog for any errors?

Member 11137292 17-Mar-17 8:37am View

Do you mean something like this?

Select Sum(TableTotal) AS GrandTotal
FROM (
Select Sum((isnull(cast(Quantity as float),0))) AS TableTotal from dbo.table1
UNION ALL
Select Sum((isnull(cast(Quantity as float),0))) AS TableTotal from dbo.table2
) AS SourceData

Member 11137292 10-Mar-17 8:26am View

try taking the comma out just before the "PRIMARY KEY" in your create table statement

from:
Id INT(6) UNSIGNED AUTO_INCREMENT, PRIMARY KEY

to:
Id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY

Member 11137292 7-Oct-16 9:01am View

good point, it all depends on what is consuming the data. OP makes no reference to programming language, just SQL.

Member 11137292 7-Oct-16 8:54am View

If its a number of time units you could add them to a base datetime, although the @mydate value causes an overflow.

declare @mydate integer

select @mydate = 1473861331

select DATEADD(hour,@mydate,'1 jan 1900' )

Member 11137292 7-Oct-16 8:51am View

What is the integer value? number of days? number of hours?

Member 11137292 22-Feb-16 2:34am View

Can you create this in http://sqlfiddle.com/

Member 11137292 28-Jan-16 5:20am View

can you post the full table definition for [sal]

Comments by Member 11137292 (Top 8 by date)