Viewing 15 posts - 3,496 through 3,510 (of 4,080 total)
Hey Lynn... somebody is impersonating you 😉
http://www.sqlservercentral.com/Forums/Topic672323-1291-1.aspx
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 10, 2009 at 1:13 pm
It's a system object. Check the Master database.
use master
select so.name,sc.text
from syscomments sc
join sysobjects so on so.id = sc.id
where text like '%syscon%'
and name like 'syscon%'
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 10, 2009 at 9:27 am
If your first three parameters are simply the on/off values and the fourth parameter is the actual search string then
where
...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 10, 2009 at 6:51 am
You're welcome. Good luck 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 4:54 pm
The only that I ever had problems with group by is when the group bys and the select didn't match perfectly
In olden days, when the pictures...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 4:41 pm
I'll echo Bruce. If you must check all four variables for nulls, there is no getting around just doing it. But maybe if you'll tell us...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 4:34 pm
There must be something you aren't showing us. There is no subquery shown in your example. The update statement you show will run without an...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 4:23 pm
Anybody for another "Queen" sing-a-long?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 4:08 pm
Yes, I remember that article. I'm old school, in that I think trust is something that has to be earned. It shouldn't be a default. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 4:05 pm
Here is how you can quickly strip the time off the date in SQL. In your query, just replace @date with your column name.
--------------------------------------------------
declare @date datetime
set @date =...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 3:41 pm
I guess they don't stop to think that maybe the help we provide on the forums is voluntary, without expectation of renumeration.
It may be that they know it's...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 3:30 pm
Saints may not beat the snot out of the unbelievers but ancient Jedi Masters do....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 1:10 pm
Group By doesn't guarantee distinct results
The above quote comes from this thread in the newbies forum.
http://www.sqlservercentral.com/Forums/Topic670743-1291-1.aspx#bm671705
Gail, weren't you the person who observed that GROUP...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 11:27 am
My pleasure. Good luck.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 8:35 am
Hey Gail and Steve,
Please understand, I wasn't suggesting anything as strenuous as the peer review my friend has to go through. I was just trying to 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
March 9, 2009 at 8:28 am
Viewing 15 posts - 3,496 through 3,510 (of 4,080 total)