access denied is usually because the account the SQL service is running from doesn't have access to teh specific folder the mdf exists in;

for example, if the mdf is on...

if you change form inner join to left outer joins, won't you get the desired results, where the string is in one or more tables??

thbe error is here: you are mixing the old comma delimited join style up with the newer explicit join;

you should stick with the newer version, since it makes it clearer...

that's what we keep...

for the pipe delimited row terminator, you need to add -t"|" to the command ; see bcp /? from a command prompt for all the options.

you didn't show your bcp commnad at all.

in theory, it will look something like this, assuming calling from xp_cmdshell:

EXECUTE master.dbo.xp_cmdshell 'bcp "EXEC DatabaseName.dbo.up_CheckProc";1 ''ZZZ'', 1, 0, 1, 1, ''2020-04-01 00:00:00.000'',...

just formatted for readability:

SELECT

MPC_A."DOC_DT",

MPC_A."DOC_NO",

PROD_REQR."doc_no",

PROD_REQR."doc_dt",

PROD_REQR."a_code",

PROD_REQR."p_reqr",

PROD_REQR."p_stk",

MTP_ISSUE."issue",

bnd_agnt."Frst_bnd",

MTP_TSTK_A."RAWQTY",

MTP_FGSTK_A."PEND_QTY"

FROM { oj...

the key to indexing and performance is going to be how they are searched in your WHERE clause.

if all 8 values are absolutely required for every search, an index with...

lol a good portion of my toolkit comes from your posts too! glad we shared a bit!

I think another way to get the IP address, without granting view server state is some of the newer built in functions that were added in 2008 and above.

SELECT ConnectionProperty('client_net_address')...

your error is in this validation line:

IF(SELECT member_no from member where member_no = @adult_member_no) is null

BEGIN

RAISERROR('Customer doesn''t exist', 11, 1)

END

if there are TWO or more rows...

does this example, where I'm applying some styles to the results help?

note i have to do a find/replace to the string to unescape some characters;

DECLARE @HTMLBody varchar(max)

Select @HTMLBody = (Select...

here's a full featured example of a trigger that sends an email, taking special care to get all rows affected, and a bunch of audit info;

CREATE TABLE WHATEVER(

WHATEVERID INT IDENTITY(1,1)...

Google Translate (German to English) (10/5/2012)

---

Hello,

I upload a catalog (about 800,000 records) from another, remote DB (via linked server).

The recovery model is set to FULL. Is it true that for...

here's one way, by joining the data on itself;

because all your sample data has either pants or shoes and socks, it's misleading, so I added a couple of dumb examples...