Viewing 15 posts - 1,966 through 1,980 (of 2,537 total)
October 24, 2018 at 9:18 am
October 24, 2018 at 8:51 am
October 24, 2018 at 7:50 am
October 24, 2018 at 7:33 am
Hi Guys
October 24, 2018 at 4:28 am
The limitations I have is the DB I am working on...
October 23, 2018 at 5:14 pm
October 23, 2018 at 9:45 am
October 23, 2018 at 9:38 am
nick.hinton - Tuesday, October 23, 2018 9:21 AMTry using the Parsename function:
https://docs.microsoft.com/en-us/sql/t-sql/functions/parsename-transact-sql?view=sql-server-2017
Nice idea!;WITH myTable AS
(
SELECT *...
October 23, 2018 at 9:36 am
select h.productkey,s.StartSaleDateKey, s.EndSaleDateKey, avg(l.SaleAmount)
from #headerTable h
cross join #saleDateTable s
left join #lineTable l
ON l.SaleDateKey between s.StartSaleDateKey and s.EndSaleDateKey
AND l.ProductKey =...
October 23, 2018 at 8:05 am
I usually put a commented out print before the exec so you can uncomment it in these situationsPRINT @sql_stmt
October 23, 2018 at 7:56 am
;WITH myTable AS
(
SELECT * FROM (VALUES ('00010.1351.100'),
('00010.2112'),
('00025.1351.100'),
('00115.1351.100'),
('120010.1351.100'),
('120010.2112'),
('180025.1351.100'),
('1360000.5111.100'),
('1360000.5161.500'),
...
October 23, 2018 at 7:44 am
;with myTable (StartDate ,EndDate) AS
That semicolon 'initiator' is there just to...
October 22, 2018 at 5:07 pm
October 22, 2018 at 4:54 pm
Viewing 15 posts - 1,966 through 1,980 (of 2,537 total)