Viewing 15 posts - 14,026 through 14,040 (of 15,381 total)
jared-709193 (9/15/2011)
Is this homework? If not, the "requirement" should be suggested to be changed for efficiency 🙂Jared
And if it is homework you should suggest it be changed to your professor,...
September 15, 2011 at 2:54 pm
hardial_bhatia (9/15/2011)
SEAN,I have to use the cursor ,as according to the requirement, so no wayout.
Your boss actually mandates that you use a cursor?
September 15, 2011 at 2:48 pm
That looks like your transaction count will be consistent at this point. If you want to try improve this process and get rid of those **cough**cursors**cough** let us know and...
September 15, 2011 at 2:39 pm
I don't see any reason in here at all that you need a cursor. You aren't doing anything but updates. This could be converted to be entirely set based and...
September 15, 2011 at 2:31 pm
Chris Souchik (9/15/2011)
USE [TransactionalData]
GO
DECLARE @return_value int
declare @itm_cd varchar (30)
declare @del_doc_num varchar (30)
declare @ItemCode varchar (30)
declare @DelDoc varchar (30)
set @itm_cd = (select itm_cd from temp_sales_order_cbo...
September 15, 2011 at 12:51 pm
dougb 34607 (9/15/2011)
My problem is that my ERP system stored a formula in sql as a string. Our ERP program uses C and does not have a problem using the...
September 15, 2011 at 8:05 am
I haven't tried my hand at any stored procedures yest and I am not sure if I can call that procedure in a view or directly into my report writer.
No...
September 15, 2011 at 7:42 am
You're welcome. glad you figured it out.
September 14, 2011 at 12:05 pm
Yeah this is very common recursive cte and it looks like you have it spot on. From you sample data it is orphaned due to the lack of the '0001'...
September 14, 2011 at 12:01 pm
Looks like you posted just before I hit send. There is really no way to "resolve" it. Your query can't possibly return records that don't exist. There is no record...
September 14, 2011 at 11:47 am
Thanks for the tables and data. 🙂
Your query is spot on correct and it returns exactly what it should. You said it should return a record for '0001' but that...
September 14, 2011 at 11:46 am
Looks like you are fairly new around here. This is pretty hard to help because we don't have the ddl and sample data (insert statements) along with desired output based...
September 14, 2011 at 11:22 am
We are here to help, not do your job for you. Not trying to sound snarky but you are obviously trying to do something that you don't understand. I can't...
September 14, 2011 at 11:09 am
That certainly looks like it would be easier to determine how to parse it, however it doesn't look it has the trailer info like you posted from the first link....
September 14, 2011 at 10:56 am
tkatona-1119058 (9/14/2011)
However if client_list contains the value 99,3014,118,196,163,131,185,191,62,18,101,81,3007
doing a like 9% would return this row, when it would not be valid?
Also would return a row with a value of 95....
September 14, 2011 at 9:43 am
Viewing 15 posts - 14,026 through 14,040 (of 15,381 total)