Viewing 15 posts - 1,141 through 1,155 (of 1,396 total)
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
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
I think it would be more accurate and far less work to rely on the existing constraints.
Yes yes. Even if checks are performed in advance it's no guarantee the...
February 12, 2020 at 5:37 pm
DBCC TIMEWARP at its best.
Then set the recovery model to "Trust Me We'll Be OK"
February 11, 2020 at 2:00 pm
What happens if you restart the service? According to the docs the service needs to be restarted after 'set sqlagent.enabled true'. If that doesn't work I'd make a support call.
February 11, 2020 at 1:02 pm
According to the timestamps you answered your own question half a day before it was even asked!
February 11, 2020 at 12:50 pm
You could create a table (b_tree) to store your numeric data in a single column. Then assign additional columns based on common attributes of the numbers.
column1: your numbers
column2: applies to...
February 11, 2020 at 12:33 pm
Viewing 15 posts - 1,141 through 1,155 (of 1,396 total)