Viewing 15 posts - 3,481 through 3,495 (of 5,109 total)
SELECT DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()) +1, 0) AS QStart,
DATEADD(DAY, -1, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()) +2, 0)) AS QEnd;
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 19, 2017 at 7:21 am
Anyone having problems creating topics? I'm trying to post one and it just sits there for a few minutes, then I get an unknown error. Tried a few times. Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 19, 2017 at 7:02 am
;WITH MAX_SET AS
(
SELECT
FT.Employee_SID
,MAX(FT.Team_SID) AS MX_TSID
FROM dbo.FactTable FT
GROUP BY FT.Employee_SID
)
UPDATE FT
SET...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 19, 2017 at 5:56 am
Shanmuga Raj - Wednesday, July 19, 2017 5:27 AMcan you help me with exact query
my table is cdw.FactTable
Rather than giving you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 19, 2017 at 5:46 am
Your table is called FactTable. I used a temporary table in my example.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 19, 2017 at 5:20 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 19, 2017 at 5:02 am
I donot have access to change your database design. The above table have...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 19, 2017 at 4:46 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 19, 2017 at 4:30 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 19, 2017 at 4:25 am
Personally, this looks like, to me, that you have a many to many relationship in your table structure, These aren't ideal. Do you have access to change your database design?...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 19, 2017 at 4:20 am
Use BETWEEN:WHERE Id BETWEEN 1 AND 5;
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 19, 2017 at 4:01 am
Select
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 19, 2017 at 2:34 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 19, 2017 at 1:46 am
Microsoft docs also covers how to do this as well, on sp_send_dbmail (Transact-SQL). Have a look for Example C; "Sending an HTML e-mail message".
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 19, 2017 at 1:40 am
Looks like you're trying to update the existing (float) column with a date, which won't work. you'll need a new column, and then (if you want) you can drop the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 18, 2017 at 10:07 am
Viewing 15 posts - 3,481 through 3,495 (of 5,109 total)