ts itself. If I fought every stupid thing we have to deal with here I'd
do nothing but battle every day.
- Original Message
From: Dean H. Saxe <[EMAIL PROTECTED]>
To: discussion@acfug.org
Sent: Tuesday, June 5, 2007 2:52:32 PM
Subject: Re: [ACFUG Discuss] OT: SQL help
Or he ha
esday, June 05, 2007 5:03 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] OT: SQL help
For SQL Server 200, the master database holds the information for the
metadata for databases on that particular server instance.
If you have access to this database, there should be some views pre-ma
-
From: Dusty Hale
To: discussion@acfug.org
Sent: Tuesday, June 05, 2007 4:41 PM
Subject: RE: [ACFUG Discuss] OT: SQL help
I'm afraid I don't have any experience using metadata. I looked at the
metadata folder icon in enterprise manager but nothing obvious to me so I gues
ed by it.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean
H. Saxe
Sent: Tuesday, June 05, 2007 4:02 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] OT: SQL help
So you'd rather have no foreign key relationships and let the DB
get all out of whack rather than fig
Thanks for the suggestion and I'll try to look into how to use metadata.
Dusty
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe
Sent: Tuesday, June 05, 2007 4:23 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] OT: SQL help
Fair enough.
L PROTECTED] On Behalf Of Dean H.
Saxe
Sent: Tuesday, June 05, 2007 4:02 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] OT: SQL help
So you'd rather have no foreign key relationships and let the DB
get all out of whack rather than figure out the DTS issues? I think
you're loo
PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] OT: SQL help
So you'd rather have no foreign key relationships and let the DB get all out
of whack rather than figure out the DTS issues? I think you're looking at
the wrong problem, I'd spend my time figuring out the DTS and
2:16 PM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] OT: SQL help
Teddy,
Any idea why do I get an error in Query Analyzer :
SQL Statement
SELECT *
FROM dbo.ORDER_ITEMS oi LEFT OUTER JOIN
dbo.AP_translation tr ON tr.option_id IN
(select convert(int,Value)
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Morton
Sent: Tuesday, June 05, 2007 2:16 PM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] OT: SQL help
Teddy,
Any idea why do I get an error in Query Analyzer :
SQL Statement
SELECT *
FROM dbo.ORDER_ITEMS oi
t;[EMAIL PROTECTED]>
To: discussion@acfug.org
Sent: Tuesday, June 5, 2007 2:09:40 PM
Subject: Re: [ACFUG Discuss] OT: SQL help
You use it in an adhoc query in query analyzer or SSMA. I have not
tried it as an ad hoc query in CF as I myself tend not to use
cfquery wherever I can.
Teddy
- O
: [ACFUG Discuss] OT: SQL help
Why is that? You don't still believe that stored procedures always perform
better do ya? ;)
- Original Message
From: Teddy R Payne <[EMAIL PROTECTED]>
To: discussion@acfug.org
Sent: Tuesday, June 5, 2007 2:09:40 PM
Subject: Re: [ACFUG
Why is that? You don't still believe that stored procedures always perform
better do ya? ;)
- Original Message
From: Teddy R Payne <[EMAIL PROTECTED]>
To: discussion@acfug.org
Sent: Tuesday, June 5, 2007 2:09:40 PM
Subject: Re: [ACFUG Discuss] OT: SQL help
Message
Yo
07 12:10 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] OT: SQL help
You use it in an adhoc query in query analyzer or SSMA. I have not tried
it as an ad hoc query in CF as I myself tend not to use cfquery wherever I can.
Teddy
- Original Message -
Maybe I missed something, but why wouldn't you just use a cfqueryparam with a
type of sql_int and list="yes".
- Original Message
From: Paul Morton <[EMAIL PROTECTED]>
To: discussion@acfug.org
Sent: Tuesday, June 5, 2007 1:36:40 PM
Subject: [ACFUG Discuss] OT: SQL
rg
Sent: Tuesday, June 05, 2007 1:58 PM
Subject: RE: [ACFUG Discuss] OT: SQL help
Without creating a SP, can I use this in a select statement?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teddy R Payne
Sent: Tuesday, June 05, 2007 11:45 AM
To: discus
Subject: RE: [ACFUG Discuss] OT: SQL help
Without creating a SP, can I use this in a select statement?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teddy R Payne
Sent: Tuesday, June 05, 2007 11:45 AM
To: discussion@acfug.org
Subject: Re
iate quick statements so that I can
alleviate miscommunication for our more detailed members.
Teddy
- Original Message -
From: Dean H. Saxe
To: discussion@acfug.org
Sent: Tuesday, June 05, 2007 1:49 PM
Subject: Re: [ACFUG Discuss] OT: SQL help
Sure it is, Teddy. 1NF requi
Without creating a SP, can I use this in a select statement?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teddy R Payne
Sent: Tuesday, June 05, 2007 11:45 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] OT: SQL help
Paul,
There is already an
e 05, 2007 1:33 PM
Subject: Re: [ACFUG Discuss] OT: SQL help
Even further off topic... why in the heck does a varchar have a
comma delimited list in it? That violates the first degree of
normalization.
Also, why do you need to split it for an in clause? If the field
data is wrapped
Message -
From: Dean H. Saxe
To: discussion@acfug.org
Sent: Tuesday, June 05, 2007 1:33 PM
Subject: Re: [ACFUG Discuss] OT: SQL help
Even further off topic... why in the heck does a varchar have a comma
delimited list in it? That violates the first degree of normalization.
Also
@acfug.org
Subject: Re: [ACFUG Discuss] OT: SQL help
Even further off topic... why in the heck does a varchar have a comma
delimited list in it? That violates the first degree of normalization.
Also, why do you need to split it for an in clause? If the field data is
wrapped in parenthesis, sh
sday, June 05, 2007 1:36 PM
Subject: [ACFUG Discuss] OT: SQL help
I apologize for the OT post, but I'm getting frustrated.
I am attempting to use a UDF to split a varchar (comma delimited list of
ints) in an IN clause in a SQL statement, and I'm not able to get the SQL
statement
Even further off topic... why in the heck does a varchar have a comma
delimited list in it? That violates the first degree of normalization.
Also, why do you need to split it for an in clause? If the field
data is wrapped in parenthesis, shouldn't it work as is?
-dhs
Dean H. Saxe, CISSP
I apologize for the OT post, but I'm getting frustrated.
I am attempting to use a UDF to split a varchar (comma delimited list of
ints) in an IN clause in a SQL statement, and I'm not able to get the SQL
statement to pass a Table field to the UDF.
I'm hoping someone sees a glaring error, or can
24 matches
Mail list logo
