Viewing 15 posts - 16 through 30 (of 152 total)
January 30, 2018 at 9:31 am
Thank you to you all! Helps bigtime. I need to really learn date and time functions.
December 19, 2017 at 1:00 pm
select *
from TicketItem
where s_item IN('Coffee', 'Espresso', 'Double Espresso', 'Decaf Espresso', 'Cappucino', 'Latte', 'Iced Coffee', 'sm coffee pot', 'lg coffee pot')
and dt_when >=...
December 19, 2017 at 12:01 pm
CREATE TABLE mytable(
i_ticket_id INT NOT NULL PRIMARY KEY
,s_item VARCHAR(50) NOT NULL
,dt_when DATETIME NOT NULL
,c_price MONEY...
December 19, 2017 at 11:59 am
December 19, 2017 at 11:41 am
December 19, 2017 at 11:22 am
If finding rows by birth month without regard to year or day is something...
November 22, 2017 at 8:51 am
Thom A - Friday, November 17, 2017 10:05 AMWrap the ISNULL around your SUM instead.
SELECT
'$' + CONVERT(VARCHAR(12), ISNULL(SUM(CAST([ie].[AMOUNT] AS...
November 17, 2017 at 10:22 am
October 26, 2017 at 3:07 pm
DATETIME = DATEADD(DAY,-6,@Yesterday)DATETIME = CAST(GETDATE() AS DATE)So that gets me data...
October 26, 2017 at 2:41 pm
http://caspian.dotconf.net/menu/Software/SendEmail/
I use SendMail...works like a charm and super easy to setup.
October 26, 2017 at 2:26 pm
Viewing 15 posts - 16 through 30 (of 152 total)