cdun2 | SQLServerCentral

cdun2

Forum Replies Created

Viewing 15 posts - 196 through 210 (of 250 total)

RE: Convert Columnar Data to Row Data

quote:
That's why I included a where clause so that if you specif y one studentID you will get 75 rows you could...

December 3, 2003 at 2:09 pm

#484534
RE: Convert Columnar Data to Row Data

quote:
Select StudentID as Student,
Case When n = 1 THEN Q1
...

December 2, 2003 at 11:31 am

#484331
RE: Subquery Problem

quote:
Since you won't be returning any duplicates, and since you aren't ORDERing the data, you should use UNION ALL to improve performance.

November 18, 2003 at 11:52 am

#482489

RE: Subquery Problem

quote:
Unless I'm missing something, you could make your life easier by treating this as two separate queries and joining the results with...

November 17, 2003 at 4:24 pm

RE: Replacing Specific Characters in a Text String

I glanced at REPLACE, and it didn't occur to me at the time that I could just use the 'LastName' field name in the first expression.

Thanks for your help!

CSDunn

October 21, 2003 at 3:34 pm

RE: Date Constraint

Thanks for your help!

CSDunn

October 14, 2003 at 11:13 am

RE: Exec Stored Procedure from a View

quote:
Can you post more details of what you want out?

I have a fix for...

October 7, 2003 at 10:03 am

RE: Need Alternative to Stored Procedure

Thanks for these ideas. I had thought that not having NOCOUNT on might be a problem, and I will try this.

CSDunn

October 3, 2003 at 1:26 pm

RE: Need Alternative to Stored Procedure

quote:
Call the SP with a Pass-Through query in access.

I'm not sure if Pass-Through queries work...

October 2, 2003 at 12:59 pm

RE: Default Parameter Value Part II

Thanks for your help. I have a table that already contains the unique school numbers. The table is called 'tblLocation'.

I edited the procedure as follows:

*****************************************

ALTER PROC InstrumentStudentAssign2_sp

@SchoolNum smallint...

September 24, 2003 at 4:28 pm

RE: Default Parameter Value

Thanks for your help with this. I need to expand on the SP, and will put another post out for some questions I have about it.

September 24, 2003 at 2:20 pm

#475676

RE: Job Title Questions

Thanks, this is very helpful! CSDunn

September 19, 2003 at 10:19 am

RE: Questions about Job Titles

quote:
What is DB4 ? Is that a clustered DB2 system ?

September 19, 2003 at 10:14 am

RE: Related to Certification

Thanks, this is very helpful!

CSDunn

August 28, 2003 at 2:36 pm

RE: Related to Certification

quote:
All are survey based and depend on the answers being correct.

One of the recruiters...

August 25, 2003 at 12:09 pm

Viewing 15 posts - 196 through 210 (of 250 total)