Viewing 15 posts - 20,356 through 20,370 (of 26,490 total)
How about posting the code for dbo.udf_GenerateNextFilename?
June 22, 2009 at 10:36 am
businessintelligence2010 (6/22/2009)
What is not right below? I am trying to pull a data from another table where 'Inncode' from tblOTSOrder = first 5 character from 'Site_Id' from tblSRO378.
select
tblOTSOrder.InnCode,
tblSRO378.Order
FROM tblOTSOrder
INNER...
June 22, 2009 at 10:33 am
Actually, if I did the search correctly, I found 5 SELECT DISTINCT statements in the code.
Edit:
And 3 cursors.
June 22, 2009 at 10:23 am
I have to agree whole heartly with Grant on this one. I'd want to get paid to work on that one. Lot of code, not a lot of...
June 22, 2009 at 10:20 am
Eswin (6/18/2009)
Hi ExpertzPerformance wise Which is better
...
And please provide me a good cursor example (ie optimized cursor eexample).
Isn't this, optimized cursor an oxymoron?? 😉
June 22, 2009 at 10:09 am
rockingadmin (6/22/2009)
Lynn Pettis: i didn't look for complete solution man, to get some idea only.
Not the impression I got from the title or wording of your original post.
Still,...
June 22, 2009 at 10:03 am
Andy Hughes (6/22/2009)
PaulB (6/21/2009)
June 22, 2009 at 8:30 am
Do a search on this site for the Tally table. You shouldn't be using a recursive CTE for this, but I could still seeing use two CTE's.
June 22, 2009 at 8:28 am
I'd also like to see what you have done on your own first. We aren't here to write code on-demand, we are here to help people solve problems and...
June 22, 2009 at 8:26 am
Paul,
Unless you are talking about the link to sqlteam (which I didn't follow), the opening code in both code blocks are both using a cursor and while loop. The...
June 22, 2009 at 6:39 am
Slightly confused. What are you attempting to accomplish and what is SSMA?
June 22, 2009 at 1:00 am
If you post your table DDL, sample data (in a readily consummable format), and expected results for the paging code based on the sample data, I'm sure you will get...
June 22, 2009 at 12:59 am
Curious why you are using a cursor in your code. As this is posted in a SQL Server 2005 forum, I thought I'd post a simplified version of some...
June 22, 2009 at 12:56 am
nalmir.hugo (6/21/2009)
my services will not provide these features. It''s a good question in a ERP scope.
It's something you should consider. Remember, the companies using your server are your...
June 21, 2009 at 4:41 pm
Just noticed how many posts on The Thread so far. Pretty sure we will be having our 6000th post party before the end of the week!
June 21, 2009 at 4:31 pm
Viewing 15 posts - 20,356 through 20,370 (of 26,490 total)