Viewing 15 posts - 31 through 45 (of 55 total)
I recently worked on some hierarchical stuff, and yeah -- there's not much in T-SQL to do the work for you! I had to build a handful of routines...
September 23, 2003 at 11:54 am
sachindedhiya
quote:
How about trying this???SELECT ... /* various fields */
FROM PatientInfo
WHERE UserID = CASE
WHEN @Id > 0 THEN @Id
ELSE UserID
END
September 23, 2003 at 8:53 am
Thanks, everyone! I do love this community, for just this reason.
Mark and Sachindedhiya -- for the purposes of my actual task at
hand, it seems like both of your suggestions...
September 19, 2003 at 1:08 pm
quote:
Did you see the SQLServer Community update for today?It was advertising Kim DeLaney's new book...
Fantastic....
June 25, 2003 at 10:49 am
First, everyone -- Thanks for lending your brains to this issue! I didn't expect so many replies, and I'm learning much myself as I go. Some observations, though,...
June 25, 2003 at 9:34 am
Everyone,
Thanks, I will look into those tools. And thanks for the suggestion
about setting up and tearing down a DSN. I would be delighted if
such a simple task...
October 30, 2002 at 3:33 pm
quote:
I know it seems ridiculous to format your pc for a thing that should be easy, but microsoft made this big mistake...
October 28, 2002 at 11:55 am
quote:
...If it is working format your other client and install windows 2000 again.
Ouch. ...
October 28, 2002 at 7:26 am
quote:
At your IIS machine, have you tried to create a SUer or system DSN? I will try that to see if your...
October 25, 2002 at 2:34 pm
I turned on auditing for failures, looking for some more detail on why the connection is failing. Nothing shows up in either the Win2K event logs or the MSSQL...
October 25, 2002 at 6:12 am
quote:
I'm cracking up, folks.
Responding to my own message here...
Big question that's rolling around my brain....
October 24, 2002 at 6:36 pm
Matthew, Antares686 and Chris -
Thanks, all of you. Matthew, thanks for the elaboration on Chris' point -- which now of course makes much sense. If something is indexed,...
October 11, 2002 at 10:43 am
quote:
The way to build is to consider each SELECT individually and build them with the proper WHERE cluse and input fields, then...
October 11, 2002 at 7:43 am
quote:
Just remember that even if you use an indexed view you are essentially copying the data and storing it in another location.
October 11, 2002 at 7:33 am
Andy/Antares686,
Thanks for the input! So it sounds like Access itself is pretty suspect, in how it (man-)handles the connection to MSSQL when used as both a source and...
October 9, 2002 at 8:20 am
Viewing 15 posts - 31 through 45 (of 55 total)