Viewing 15 posts - 1,096 through 1,110 (of 1,360 total)
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%5B/quote%5D
The OP is splitting nvarchar(255) and Jeff's other splitter 'DelimitedSplitN4K' targets...
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
I will be dealing with 2000 tables and approx 1 million in some tables.
It is a data migration from one system to another with a mapping in between of...
February 13, 2020 at 2:24 am
update c
set
dob=i.dob
from
customers c
join
info i on c.id=i.id;
February 12, 2020 at 10:17 pm
Does this return the correct answer?
declare
@company_name varchar(36)='Cash4WhateverTX',
@return_code ...
February 12, 2020 at 8:08 pm
;with
c4w_cte(co_name_count) as (
SELECT CAST((Count(rr.[company_name]) + 1) AS decimal(10,2))
FROM [dbo].[return_rows] rr
WHERE [return_code] = 'R01'
AND rr.[company_name] =...
February 12, 2020 at 7:08 pm
Viewing 15 posts - 1,096 through 1,110 (of 1,360 total)