Viewing 15 posts - 3,481 through 3,495 (of 5,111 total)
For some reason i can't make topics on my PC anymore, nor can i put the below in the actual topic's post. So the above is just a holding psot,...
July 19, 2017 at 7:35 am
SELECT DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()) +1, 0) AS QStart,
DATEADD(DAY, -1, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()) +2, 0)) AS QEnd;
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.
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...
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...
July 19, 2017 at 5:46 am
Your table is called FactTable. I used a temporary table in my example.
July 19, 2017 at 5:20 am
July 19, 2017 at 5:02 am
I donot have access to change your database design. The above table have...
July 19, 2017 at 4:46 am
July 19, 2017 at 4:30 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?...
July 19, 2017 at 4:20 am
Use BETWEEN:WHERE Id BETWEEN 1 AND 5;
July 19, 2017 at 4:01 am
Select
July 19, 2017 at 2:34 am
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".
July 19, 2017 at 1:40 am
Viewing 15 posts - 3,481 through 3,495 (of 5,111 total)