ABCD,WXYZ' LIKE '%'+TOTO+'%'
Thank you all for the help!
Pascale Sterrett
Kenavo ar wech all
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Monday, March 16, 2015 12:58 PM
To: arslist@ARSLIST.ORG
Subject: Re:
s you the path to accomplish what you want to accomplish
with your command.
Doug Mueller
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of pascale.sterr...@daimler.com
Sent: Friday, March 13, 2015 10:19 AM
To: arslist@ARSLIST.ORG
Subject: SQL question
What do you think I did??
Thank you,
Pascale Sterrett
Kenavo ar wech all
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Pat Zandi
Sent: Friday, March 13, 2015 10:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL question
**
Do yourself a favor
day, March 13, 2015 12:19 PM
To: arslist@ARSLIST.ORG
Subject: SQL question
**
Hello all,
I need some help with an SQL query
This is driving me crazy Short drive these days
The is an alpha numerical value but for explanation purpose I am using ABCDs
The length of the test_value will vary
Do yourself a favor; log into admin console turn in logging SQL turn on.Go
to form and do a basic query, stop logging and you have now a perfect example
Sent from my iPhone
> On Mar 13, 2015, at 1:18 PM, pascale.sterr...@daimler.com wrote:
>
> **
> Hello all,
>
> I need some help with
Hello all,
I need some help with an SQL query
This is driving me crazy Short drive these days
The is an alpha numerical value but for explanation purpose I am using ABCDs
The length of the test_value will vary from record to record
Original values
test_value (536870962) = ABCD,WXYZ
Tried:
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Direct SQL question - in Log file
ARACTSQL("xxx",0,-1,-2,100161)
**
True, but smiley could do something like
Action 1 Set Fields setting a display only integer field to $SERVERTIMESTAMP$
Action
: Direct SQL question - in Log file
ARACTSQL("xxx",0,-1,-2,100161)
**
So for my edification, why aren't you using the AR Time Functions?
On Tuesday, May 8, 2012 2:20:28 PM UTC-5, smiley wrote:
Hi all -
I thought maybe I have my Direct SQL sort of working now. But I ca
I'm trying to update are still blank:
> SELECT
> Incident_Number,UM_Opened_By,UM_Opened_Date,Last_Modified_By,Last_Modified_Date
>
>
> FROM HPD_Help_Desk where Incident_Number='INC00031823';
>
> Thank you for any help!!!
>
>
> --
J
*From:* Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] *On Behalf Of *Joe Martin D'Souza
*Sent:* Tuesday, May 08, 2012 4:28 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Direct SQL question - in Log file
ARACTSQL("xxx",0,-1,-2,100161)
**
That’s wh
achieve the same results with any of the native ARS
functions..
I do understand this kind of qualifies to be one such example..
Joe
From: Axton
Sent: Tuesday, May 08, 2012 4:19 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Direct SQL question - in Log file
pened_By,UM_Opened_Date,Last_Modified_By,Last_Modified_Date
> FROM HPD_Help_Desk where Incident_Number='INC00031823';
>
> Thank you for any help!!!
>
>
> --
> View this message in context:
> http://ars-action-request-system.1093659.n2.nabble.com/Direct-SQL-ques
I'm trying to update are still blank:
SELECT
Incident_Number,UM_Opened_By,UM_Opened_Date,Last_Modified_By,Last_Modified_Date
FROM HPD_Help_Desk where Incident_Number='INC00031823';
Thank you for any help!!!
--
View this message in context:
http://ars-action-request-system.1093659.n2.n
.
Thanks for your answer on MS SQL.
Dave
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Pancia
Sent: Wednesday, February 29, 2012 12:05 AM
To: arslist@ARSLIST.ORG
Subject: Re: MS SQL question
**
Dave,
Sorry. I
SQL question
**
Ø FTS is no longer separately licensed in 7.6.04
To clarify, FTS is separately licensed in 7.6.04 still, but it is now a server
based license. Previous versions used a user-based licensing model.
For customers who have purchased the ITSM Suite under suite pricing
discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta
Sent: Wednesday, February 29, 2012 12:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: MS SQL question
** No performance hits in Oracle if you follow my post:
http://theremedyforit.com/2011/12/case-insensitive-in-remedy
[mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Shellman, David
> *Sent:* Tuesday, February 28, 2012 4:57 PM
>
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: MS SQL question
>
> ** **
>
> **
>
> Brian,
>
> ** **
>
> I understand. As I said I'm
y 28, 2012 4:57 PM
To: arslist@ARSLIST.ORG
Subject: Re: MS SQL question
**
Brian,
I understand. As I said I'm not asking which is better. I'm attempting to
understand if there are any hidden gotchas with MS SQL like there is with
Oracle.
There my not be any but that is what
to:arslist@ARSLIST.ORG] On Behalf Of Brian Pancia
Sent: Tuesday, February 28, 2012 3:51 PM
To: arslist@ARSLIST.ORG
Subject: Re: MS SQL question
**
Dave,
Case Sensitivity is not an issue with MS SQL. Also with 7.6.04 you have FTS,
which provides better search capabilities for both Oracle and SQL. In m
ve to manage.
Brian
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David
Sent: Tuesday, February 28, 2012 2:00 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: MS SQL question
**
I know that there are a couple of s
discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David
Sent: Tuesday, February 28, 2012 2:00 PM
To: arslist@ARSLIST.ORG
Subject: MS SQL question
**
I know that there are a couple of short comings with running the AR System
on Oracle. Namely case sensitivity and
I know that there are a couple of short comings with running the AR System on
Oracle. Namely case sensitivity and searching a large character field. I'm
wondering if there are short comings running on MS SQL. Not really looking for
a debate on the advantages of one over the other. Just looki
riginal Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Sokol, Brian
Sent: Friday, April 04, 2008 12:37 PM
To: arslist@ARSLIST.ORG
Subject: SQL Question
**
Hi Our Remedy database (MS Sql 2000) has grown from 4GB to 52GB in the
past fe
Hi Our Remedy database (MS Sql 2000) has grown from 4GB to 52GB in the
past few months. I had turned on auditing for our asset database . The
auditing table is huge. That was the cause. I turned off auditing and
then late last night deleted the table from ARAdmin. I no longer see the
table in Remed
tem discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE
Sent: Thursday, March 27, 2008 7:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS6.3 + SQL Question (UNCLASSIFIED)
I think the space in the table (view) name is causing you a problem:
.vw_tbl_ARS T
MDA/DOCC
Sent: Thursday, March 27, 2008 7:52 AM
To: arslist@ARSLIST.ORG
Subject: ARS6.3 + SQL Question (UNCLASSIFIED)
Classification: UNCLASSIFIED
Caveats: NONE
Hi All!
I'm having a small problem getting my Remedy 6.3 app to talk to a remote
MSSQL Server 2K SP3 database running on a Win2k3
@ARSLIST.ORG
Subject: ARS6.3 + SQL Question (UNCLASSIFIED)
Classification: UNCLASSIFIED
Caveats: NONE
Hi All!
I'm having a small problem getting my Remedy 6.3 app to talk to a remote
MSSQL Server 2K SP3 database running on a Win2k3, SP2 machine. My AR
server
is running on a Win2k SP4 ma
Classification: UNCLASSIFIED
Caveats: NONE
Hi All!
I'm having a small problem getting my Remedy 6.3 app to talk to a remote
MSSQL Server 2K SP3 database running on a Win2k3, SP2 machine. My AR server
is running on a Win2k SP4 machine, with the AR System database running on a
MSSQL Server 2K SP
plan to do some testing of our own on this but haven't had
the chance.
Chad Hall
(501) 342-2650
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Gallagher
Sent: Wednesday, August 01, 2007 8:44 AM
To: arslist@ARSLIST.
In short adding, modifying, and deleting data causes fragmentation. I
googled it to see what I could come up with. Here is a pretty good
link on managing fragmentation:
http://mssqltips.com/tip.asp?tip=1165
--- "Dudley, Joelie" <[EMAIL PROTECTED]> wrote:
> Question for you SQL gurus out there.
Take a look at this:
http://www.sqlservercentral.com/columnists/chedgate/fragmentation101.asp
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
Question for you SQL gurus out there.
MS SQL 2000 - what makes database tables get fragmented? Is it normal
for this to occur?
Any help on this would be greatly appreciated as our Remedy SQL database
has hundreds of fragmented table.
Thanks,
Joelie Dudley
Application Developer
555 Walnut Stree
32 matches
Mail list logo