Ronda, I assume you used Jeff's cursor layout and got it working? Otherwise we could continue tweaking your stored proc until it worked. Happy to help. -- Dave...
1227
Ronda
rka@...
Jan 27, 2005 4:21 pm
I can't get either of the two (which I am working in two windows) to work. Yours is returning that bizaare error about the "C" sproc... Please continue to help...
Here you go: IF EXISTS (SELECT null FROM sysobjects where name = 'GetConsolidatedProductLines' ) DROP PROC GetConsolidatedProductLines GO CREATE PROC...
1229
Ronda
rka@...
Jan 27, 2005 5:16 pm
Dave, THANK you for taking the time to help me with this. I changed one variable 'name' to '[description]' and got it to run. BUT it is not returning any...
Notice the line: Set @InsertColor = ISNULL(@color + ',','') If your empty color and size fields are NOT null then what will happen is you'll get screwy Insert...
1231
Jeff Palmer
jeffp@...
Jan 27, 2005 11:23 pm
Do you get a '0 rows affected' message? Jeff Palmer E-Commerce Manager Ohio Wholesale, Inc. 330-769-5050 ext 136 jeffp@... www.ohiowholesale.com ...
1232
Jeff Palmer
jeffp@...
Jan 27, 2005 11:23 pm
Would like to see your current example Jeff Palmer E-Commerce Manager Ohio Wholesale, Inc. 330-769-5050 ext 136 jeffp@... www.ohiowholesale.com ...
1233
Jeff Palmer
jeffp@...
Jan 27, 2005 11:23 pm
Are you getting '0 rows affected'? Jeff Palmer E-Commerce Manager Ohio Wholesale, Inc. 330-769-5050 ext 136 jeffp@... www.ohiowholesale.com ... ...
1234
Jeff Palmer
jeffp@...
Jan 27, 2005 11:23 pm
I would actually recommend going with a stored procedure unless overhead is not an issue. Cursors tend to burden the server as well as create locking issues. ...
Here's hopin' I'm using MS-SQL on SQL7 and 2000 Given this dataset: KeywordsTable: keyID___key___ownerID 1_______A_____0 (indicates no owner) 2_______B_____1...
1236
Jeff Palmer
jeffp@...
Jan 27, 2005 11:24 pm
A cursor won't typically return records to your screen (I think) you can use the print command within your fetch to spit out the variables you are calling or...
hi everybody,, I am new to this group . I want some info. abt Joins with examples if possible.; thanx & regards, Tripur Patel ... Do you Yahoo!? Yahoo! Search...
Hi out there. I have a intresting problem that I didnt think was so hard (at first) I have a table that simply has a structure like this Name - Age - Family...
Try this:
Select [Name] , [Age] , [Family Number],
(Select Max([Family Number])
from table as t2 where t1.[Family Number] = t2.[Family Number]...
1242
Michael Gerholdt
Michael.Gerholdt@...
Jan 31, 2005 2:09 pm
Hi out there. I have a intresting problem that I didnt think was so hard (at first) I have a table that simply has a structure like this Name - Age - Family...
1243
Arne Sevenhuijsen
Arne@...
Jan 31, 2005 2:28 pm
Hi there, I have a nice little problem that I have to solve. Let's say I have a MS windows 2003 server running IIS 6.0 with two separate MSDE SQL Server 2000...
1244
John Warner
john@...
Jan 31, 2005 2:38 pm
To show my ignorance (and learn from it), why wouldn't this work? SELECT MAX(age), name, [family number] FROM Table GROUP BY [family number], name; John Warner...
1245
John Warner
john@...
Jan 31, 2005 2:39 pm
Do you have read permission to the first (not yours) and read write to the second? John Warner...
1246
Arne Sevenhuijsen
Arne@...
Jan 31, 2005 2:51 pm
Yes I have read and write rights on both of the datbases, I am using the build in SA account... ... Van: John Warner [mailto:john@...] Verzonden:...
1247
John Warner
john@...
Jan 31, 2005 2:59 pm
In that case just use the full name of your databases. John Warner...
1248
Arne Sevenhuijsen
Arne@...
Jan 31, 2005 4:05 pm
Thanks. Then my query looks like this: SELECT * FROM Raparaties, [;Database=C:\Program Files\Microsoft SQL Server\MSSQL\Data\The Quest Company -...
1249
RAJASEKARAN S /NB...
rajasekaran.s@...
Jan 31, 2005 4:05 pm
Hi Consider this as data in a table called raj name age family no raj 25 1 priya 20 1 kumar 27 2 sandhya 29 2 abirami 19 3 sichu 16 3 now use this...
1250
John Warner
john@...
Jan 31, 2005 4:35 pm
Correct, it has an object name, let's see in MSDE you don't have query analyser but you should on Win 2003 have the mm console, examine the database(s) with it...
1251
Michael Gerholdt
Michael.Gerholdt@...
Jan 31, 2005 11:36 pm
John, Your query returns all family members in all families. All the max aggregate is doing here is getting the max age for each person in each family; so that...
Hello all, Does anybody know, off hand, the query to update all alpha data in a db to all caps? Thank you in advance, Jeff...
1253
Arne Sevenhuijsen
Arne@...
Jan 31, 2005 11:37 pm
Yes, Yes, Yes, finaly it Works!! It is a bit different then you suggested but it works anyway. Below you see my result. Actually it looks a bit like the way...
