Viewing 15 posts - 3,901 through 3,915 (of 13,877 total)
SELECT * FROM Timekeeper_t...
November 2, 2018 at 8:19 am
I found :
LEFT (OUTER) JOIN
Left JOIN is used pretty much by me,...
November 2, 2018 at 5:48 am
We need to load data from source table to summary tables on daily basis....
November 1, 2018 at 1:22 pm
This?
DECLARE @query NVARCHAR(MAX);
SET @query = N'DECLARE @specsAndModel TABLE ( specName VARCHAR(50))';
SET @query += N' INSERT INTO @specsAndModel(specName) select 1 + 1; SELECT specName...
November 1, 2018 at 11:17 am
October 31, 2018 at 8:25 am
Both images contain a Progress tab and neither contains a Results tab, so I don't understand what you are getting at here.
October 31, 2018 at 8:23 am
October 31, 2018 at 7:49 am
October 31, 2018 at 7:00 am
October 30, 2018 at 2:32 pm
What the heck does the sd stand for in sd.name
sd is aliasing sys.databases
No offence, but if you're a DBA, you should know about table aliases 🙂
October 30, 2018 at 12:49 pm
Can you give us an example of an entire query which fails - something which we can run in isolation?
October 30, 2018 at 11:42 am
October 30, 2018 at 7:45 am
October 30, 2018 at 7:21 am
October 29, 2018 at 11:17 am
Viewing 15 posts - 3,901 through 3,915 (of 13,877 total)