Viewing 15 posts - 45,691 through 45,705 (of 59,063 total)
RBarryYoung (1/20/2009)
Jeff Moden (1/20/2009)
January 20, 2009 at 9:54 pm
rio_briones (1/20/2009)
TOP
Text, ntext or image columns
DISTINCT
MIN, MAX, COUNT, STDEV, VARIANCE, AVG
SUM on a nullable expression
A derived table
Rowset function
Another view
UNION
Subqueries, outer joins, self joins
Full-text predicates like...
January 20, 2009 at 9:51 pm
Steve Jones - Editor (1/20/2009)
Don't blame VMS, it's an ignorance thing, same as any other new tool we get. Usually we give them...
January 20, 2009 at 9:48 pm
Ok... something big just changed. It couldn't see the files in that directory before, but suddenly it can. Try running the backup again.
January 20, 2009 at 9:45 pm
Heh... limits are good. Neither my driving a million rows through something nor the speediest pork chop that I can muster up will ever have the impact that a...
January 20, 2009 at 9:42 pm
You bet... thank you for the feedback.
January 20, 2009 at 9:35 pm
htilburgs (1/20/2009)
I'll try the method of Jeff, to fill my parameter.
If it doesn't work, I'll...
January 20, 2009 at 9:30 pm
Chris Morris (1/20/2009)
For now, he's still trying to figure out how to persuade someone to write his script without letting on that it's coursework.
Heh.... then there's that. 😉
January 20, 2009 at 9:28 pm
mhaskins (1/19/2009)
jpowers (1/19/2009)
Even as recently as the early 1990's I knew of managers who insisted their assistants print out their emails.That is pretty gross.
C'MON, RETIRE PEOPLE!
Heh... I've gotta ask......
January 20, 2009 at 9:22 pm
GSquared (1/20/2009)
January 20, 2009 at 9:17 pm
jcrawf02 (1/20/2009)
but your customer sequence changes on the change of the hour?
No, it changes when the SomeType column changes regardless of anything temporal.
But, I agree with everyone else......
January 20, 2009 at 9:14 pm
smunson (1/20/2009)
January 20, 2009 at 9:08 pm
Jacob Luebbers (1/20/2009)
Jeff Moden (1/20/2009)
But it wouldn't reset to 1 for the same person, would it?
Ah, I missed that key point 😀
In that case no, I've never seen a business...
January 20, 2009 at 9:04 pm
As a sidebar, there isn't really an advantage to having such an indexed view. The underlying indexes on the table are the only advantage. Indexed views become an...
January 20, 2009 at 8:59 pm
pat (1/20/2009)
create table table1
[pid] [int] IDENTITY(1,1) NOT NULL,
[num] [int] NULL,
[flag] [int] NULL,
[tp_id] [int] NULL,
[fe_id] [int] NULL,
[sym] [int] NULL,
[lbl] [nvarchar](256) NULL,
[sname] [nvarchar](256)...
January 20, 2009 at 8:57 pm
Viewing 15 posts - 45,691 through 45,705 (of 59,063 total)