Viewing 15 posts - 1,156 through 1,170 (of 1,419 total)
C4 returns no rows
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
February 18, 2020 at 9:45 pm
Could you please share the (appropriately quoted) insert statement from your original question?
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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 -...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
February 17, 2020 at 9:29 pm
Ok cool
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
February 17, 2020 at 3:14 pm
Removed
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
February 17, 2020 at 3:13 pm
Year & Quarter from the UI form.
@QuarterID bigint
@Year bigint
Bigint really? It's like parking...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
February 17, 2020 at 2:04 pm
select
concat(emp_lname, ',', emp_fname, '-', emp_key) lf_name,
city_name,
city_zip
from
emp_info;
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
February 13, 2020 at 2:24 am
Viewing 15 posts - 1,156 through 1,170 (of 1,419 total)