Viewing 15 posts - 1,126 through 1,140 (of 1,390 total)
;with
unpiv_cte as (
select
500100 Account, 2020 [Year],
100 Month1, 200 Month2, 300 Month3,...
February 20, 2020 at 1:46 pm
C4 returns no rows
February 18, 2020 at 9:45 pm
Could you please share the (appropriately quoted) insert statement from your original question?
February 18, 2020 at 8:39 pm
Could you share the (appropriately quoted) insert statement from your original question? You've asked a second question without having shared the solution to the original question. It's frustrating because we...
February 18, 2020 at 7:25 pm
I think you need a few functions for this solution. SCDecade almost had it right, to determine the @StartDate, try:
SET @StartDate = SELECT DATEFROMPARTS(@year, ((@QuarterID -...
February 17, 2020 at 9:29 pm
Ok cool
February 17, 2020 at 3:14 pm
Removed
February 17, 2020 at 3:13 pm
Year & Quarter from the UI form.
@QuarterID bigint
@Year bigint
Bigint really? It's like parking...
February 17, 2020 at 2:59 pm
SELECT ServerName + ', ' AS 'data()'
FROM ServerList
FOR XML PATH('');
That's nice. I've only ever seen string aggregation (prior to Sql Server 2016) done with the the...
February 17, 2020 at 2:04 pm
select
concat(emp_lname, ',', emp_fname, '-', emp_key) lf_name,
city_name,
city_zip
from
emp_info;
February 15, 2020 at 1:19 pm
"Excel, I love ya, but we need to talk about your personal habits..." Overall it could be a workable system although it is based (heavily) on dynamic sql. To expect...
February 14, 2020 at 7:53 pm
The file with the required json format doesn't appear to be working. It's hard to know without seeing it. Generally speaking concatenation and trimming shouldn't cause any issues. Maybe this...
February 14, 2020 at 7:36 pm
That was cheating-level easy... except you need a helper function, Jeff Moden's DelimitedSplit8K function. It's here https://www.sqlservercentral.com/articles/tally-oh-an-improved-sql-8k-“csv-splitter”-function
The OP is splitting nvarchar(255) and Jeff's other splitter 'DelimitedSplitN4K' targets nvarchar. Also...
February 14, 2020 at 2:54 pm
Not sure what TVP has to do with this. Could you provide a solution?
So I realize the OP is working with 2008R2 here. Also in 2016 the string_split() function was...
February 14, 2020 at 1:16 pm
Sorry I didn't look to see this was about Access. The following should work as a Pass-Through query:
UPDATE Items INNER JOIN Customers ON Items.ID = Customers.ID SET...
February 13, 2020 at 6:06 pm
Viewing 15 posts - 1,126 through 1,140 (of 1,390 total)