Joe Torre

Forum Replies Created

Viewing 15 posts - 481 through 495 (of 506 total)

RE: Grouping by date hour with "buckets"

Your approach much better.

February 2, 2017 at 2:38 pm

#1926491
RE: Grouping by date hour with "buckets"

Try something like:

SELECT
      CASE
         WHEN i.Duration BETWEEN '0:00:00' AND '1:00:00' THEN '0-60'
         ELSE
         CASE
            WHEN i.Duration BETWEEN '1:00:01' AND '2:00:00'...

February 2, 2017 at 1:19 pm

#1926455
RE: Calculating Dates

ajkarora - Tuesday, January 31, 2017 12:18 PM
I have a table with the following information
I want to...

January 31, 2017 at 1:17 pm

#1925947
RE: Age as of January 1st

Joe Torre - Friday, January 27, 2017 4:13 PM
Joe Torre - Friday, January 27, 2017 4:05 PM

January 27, 2017 at 4:21 pm

#1925455
RE: Age as of January 1st

Joe Torre - Friday, January 27, 2017 4:05 PM
thomashohner - Friday, January 27, 2017 3:39 PM

January 27, 2017 at 4:13 pm

#1925454
RE: Age as of January 1st

thomashohner - Friday, January 27, 2017 3:39 PM
Unfortunately that did not work. Example '01/01/1993' Should be 22 not 23. Both of our...

January 27, 2017 at 4:05 pm

#1925453
RE: Age as of January 1st

thomashohner - Friday, January 27, 2017 2:32 PM
thomashohner - Friday, January 27, 2017 2:22 PM

January 27, 2017 at 2:56 pm

#1925444
RE: sql server,parse a string to find data between delimiters/multiple occurences

forumuser15 - Thursday, January 26, 2017 7:51 PM
I have a SQL Server table with one specific nvarchar column (lets assume its called...

January 27, 2017 at 11:16 am

#1925410
RE: t-sql 2012 using error handling logic

wendy elizabeth - Friday, January 27, 2017 8:15 AM
Joe Torre - Thursday, January 26, 2017 4:01 PM

January 27, 2017 at 9:42 am

#1925386
RE: t-sql 2012 using error handling logic

wendy elizabeth - Thursday, January 26, 2017 3:47 PM
In a t-sql 2012 database, I am planning to run the following sql...

January 26, 2017 at 4:01 pm

#1925209
RE: Update flags to values

Joe Torre - Thursday, January 26, 2017 12:17 PM
Phil Parkin - Thursday, January 26, 2017 12:05 PM

January 26, 2017 at 12:19 pm

#1925160
RE: Update flags to values

Phil Parkin - Thursday, January 26, 2017 12:05 PM
I've been off sick for a few days and it seems to have taken...

January 26, 2017 at 12:17 pm

#1925159
RE: Convert number to certain value from table

Eirikur Eiriksson - Thursday, January 26, 2017 12:05 PM
Joe Torre - Thursday, January 26, 2017 11:48 AM

January 26, 2017 at 12:11 pm

#1925155
RE: Convert number to certain value from table

bryan_gomez032000 - Thursday, January 26, 2017 12:08 AM
Hi, I have table name [@tbl_value], columns are 'Code', 'Name'
Records:
Code Name
1 B
2...

January 26, 2017 at 11:48 am

#1925144
RE: Merging timeseries data to a timeseries(FromDate, ToDate) table

chandrakant_gaurav - Wednesday, January 25, 2017 8:00 AM
Hey, I have a real life problem where I received some files initially and based...

January 25, 2017 at 9:54 am

#1924908

Viewing 15 posts - 481 through 495 (of 506 total)