Viewing 15 posts - 3,901 through 3,915 (of 4,080 total)
As long as we're mentioning 2005, you can just order by the assigned name of your calculated column without bothering with a CTE. The following runs just fine...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 16, 2008 at 4:40 pm
The horror... the horror...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 11, 2008 at 2:57 pm
😛
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 11, 2008 at 1:31 pm
Winash, I would have gone with not like '%[0-9]%' being most elegant. What have you got that tops it?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 11, 2008 at 1:16 pm
Clarification please. Do you want to select only rows without numbers or do you want to return all strings, only with numbers removed?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 11, 2008 at 12:48 pm
The CTE "Days" is an example of a "Recursive" query. Just search the word "recursive" in the search block above and you will find a number of...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 11, 2008 at 12:42 pm
Please help us out by telling us what "Some Error" is.....
Remember, we don't have your tables on our servers, so we can't just cut and paste your code into a...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 11, 2008 at 12:06 pm
Porkchop Traumatic Stress Disorder
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 11, 2008 at 12:02 pm
If he moves the USE, won't the variables be okay? Looks like all he's doing is getting values for today and yesterday.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 10, 2008 at 4:26 pm
Try moving that USE docnet to the first line of your query, it's just good practice.
Now
[font="Courier New"]
WHERE do.LastModifiedTime BETWEEN @Yesterday AND @Today
AND en.DischargeDate <>...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 10, 2008 at 3:18 pm
You're welcome. I just want to make it clear that I don't recommend it in any situation where performance is, or may become, an issue. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 10, 2008 at 2:21 pm
My intention was to suggest something that would perform well, since simple is going to run poorly.
Here is the original suggestion from my first post.
It is...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 10, 2008 at 2:09 pm
I deleted my earlier query because I forgot to think outside the box. Can you work with this?
declare @integrityTbl table (integrity int primary key)
if @integrity = 'all classified'
...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 10, 2008 at 1:53 pm
:w00t:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 10, 2008 at 12:45 pm
if self then here comes the problem
then i need to join this table1 with lookuptable based on center_id and get the name from table 2 as order_source ....
just join table...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 10, 2008 at 11:26 am
Viewing 15 posts - 3,901 through 3,915 (of 4,080 total)