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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy