Viewing 15 posts - 2,491 through 2,505 (of 4,080 total)
There is no "SQL command". You code with views as if they were tables. So the tools you have to work with are the standard JOINS,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 29, 2009 at 11:03 am
Errrrr... ummmm... ahhhh....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 29, 2009 at 10:58 am
Glad to, Riz 🙂 On my machine, the loop is taking 29-30 milliseconds, on the average, to run. A couple of times it dropped to 16,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 29, 2009 at 8:21 am
Congratulations, Roy !! Keep up the good work.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 29, 2009 at 8:11 am
It would be helpful to see the full WHERE clause.
Given the 'A999A' pattern, I assume it contains something like this?
WHERE someCol like '[A-Z][0-9][0-9][0-9][0-9][A-Z]'
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 28, 2009 at 5:17 pm
Hey Seth 🙂
You inspired me to convert my CTE solution to an inline table valued function (at the bottom). Use it with a cross apply and it's not...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 28, 2009 at 5:03 pm
select '4*2,4*4,6'
Might as well make some more assumptions. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 28, 2009 at 11:23 am
A straightforward procedural solution, but it really needs to be tested against other patterns. Unless the OP (original poster) tells us otherwise, we can't assume that there will...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 27, 2009 at 4:32 pm
As time moves along, you would expect to see a change in the pattern / methodology that a person posts. If there is no change in pattern, then I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 27, 2009 at 4:00 pm
TRAVEL (ItemID = 'TR')
--------
1) SO Type of Relocation, because it hasn't been mapped to this part yet, and there are still combinations available.
2) Time Log Install, because it hasn't been...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 27, 2009 at 2:42 pm
You all do realize that in some cases SSC is the automatic transmission compared to the manual-shift F1 key? All the volunteers enable (some) people to multitask. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 27, 2009 at 1:25 pm
Chris, I'm looking at your sample data right now. What would really help me is for you to give me sample inputs and outputs. Draw...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 27, 2009 at 1:10 pm
I have to agree that coalesce is better overall in that it can handle more than two.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 27, 2009 at 10:27 am
One additional comment:
If you are ever working with FLOAT datatypes you can't use the modulo (%) operator. In that case, you can use ROUND with...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 27, 2009 at 10:18 am
Mh (8/27/2009)
Actually this code is for the source:
No, this is where you defined the source:
USING ( SELECT --@OrderID,
@orderName,
@orderType,
@orderNumber
) AS source
Per your example I shall insert this...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 27, 2009 at 9:50 am
Viewing 15 posts - 2,491 through 2,505 (of 4,080 total)