Viewing 15 posts - 2,071 through 2,085 (of 2,645 total)
I thought I'd try to do it with cross apply, I was successful up to 12 columns but then 13 broke SQL Server
Msg 8632, Level 17,...
October 24, 2018 at 2:17 pm
October 24, 2018 at 12:19 pm
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
Viewing 15 posts - 2,071 through 2,085 (of 2,645 total)