Viewing 15 posts - 661 through 675 (of 921 total)
I think you'll need to use OPENQUERY and a cursor (and a temporary table).
CREATE TABLE #ls(
Srv_Name varchar(128),
Srv_ProviderName varchar(128),
Srv_Product varchar(128),
Srv_DataSource varchar(4000),
Srv_ProviderString varchar(4000),
Srv_Location varchar(4000),
Srv_Cat varchar(128))
CREATE TABLE #LSRept(
ServerName...
October 21, 2003 at 4:00 pm
quote:
thanks jonathan for yout help, but am getting this erro" where c.Custid = o.Custid
ERROR at line 3:
ORA-00933: SQL command not properly ended"
October 21, 2003 at 3:23 pm
SELECT c.Name, c.CreditLimit, c.CreditLimit * 1.2 NewCreditLimit
FROM Cust c JOIN Ord o ON o.CId = c.CId
GROUP BY c.Name, c.CreditLimit
HAVING SUM(o.Total) > 1000
--Jonathan
October 21, 2003 at 2:36 pm
quote:
Jonathan,
Thanks Very Much.
You are welcome.
quote:
How would I...
October 21, 2003 at 1:29 pm
Why not just use REPLACE()?
UPDATE People
SET LastName = REPLACE(LastName,'''',' ')
WHERE LastName LIKE '%''%'
--Jonathan
October 21, 2003 at 1:18 pm
quote:
Hi JonathonYou're quite right that a LIKE search would do the trick. That is in fact what is currently being used,...
October 21, 2003 at 10:59 am
quote:
I prefer defaults whenever possible. In some columns (such as Termination Date in an Employees table) NULL is the...
October 21, 2003 at 10:35 am
quote:
Thanks for taking the time to respond.Jonathon: Although the productCode I used was a valid one, the table names and field...
October 21, 2003 at 10:01 am
Change your "<>" to "NOT IN".
--Jonathan
October 21, 2003 at 8:46 am
October 21, 2003 at 8:05 am
quote:
if accurate timing is needed you should use DBCC FREEPROCCACHE before running each one of them otherwise you may be using...
October 21, 2003 at 7:12 am
This is slightly faster, simpler, and doesn't assign an artificial priority to the publisher default discount:
SELECT p.pd_Id, p.pd_Name, p.pd_Price,
ISNULL(
(SELECT TOP 1 Disc
FROM
(SELECT di_Discount_Rate disc,...
October 21, 2003 at 6:52 am
How are you updating the full-text indexes? If you're using the background process, are you inserting or updating using the WRITETEXT and/or UPDATETEXT statements? Do the results of...
October 21, 2003 at 5:27 am
quote:
Jonathan,Can i wait until finish roll back? any advice.
Thanks for hreply.
If you cannot...
October 20, 2003 at 3:43 pm
quote:
Still roll back running, process stopped around 6:30am.If i stop and start the Sql services services , how long it will take...
October 20, 2003 at 3:21 pm
Viewing 15 posts - 661 through 675 (of 921 total)