Viewing 15 posts - 211 through 225 (of 250 total)
quote:
How can you ensure accuracy?
Good question. I am looking to get hired, and my...
August 25, 2003 at 10:46 am
I've applied the following to the SELECT list and it looks like I've got something to work with now:
*********************************************
IF
(SELECT COUNT( SystemUserName)AS ACount FROM Teacher_Data_Main
WHERE
SystemUserName = SYSTEM_USER or
(SystemUserName <> 'valverde\pGist'
and...
August 22, 2003 at 2:03 pm
quote:
If I used AND instead of OR, wouldn't I be asking the WHERE condition to evalueate a single record for each domain...
August 22, 2003 at 1:31 pm
I want the application to work so that when a user logs on with their domain account ('valverde\(user name)'), the application will look for a match of the SYSTEM_USER value...
August 22, 2003 at 1:09 pm
The registered server and the machine name are the same. CSDunn
quote:
Is the name of the server the same as the SQL instance...
August 19, 2003 at 1:13 pm
Thanks, this will do what I need! CSDunn
quote:
SELECT DISTINCTWorkerI
FROM tblWOWorkOrder
WHERE ISNUMERIC(WorkerI) = 0
ORDER BY WorkerI DESC
August 13, 2003 at 9:41 am
Thanks for the link to the article. One of the problems in this case is that the column, ‘WorkOrderID’ is not already and IDENTITY column, so using DBCC CHECKIDENT will...
August 7, 2003 at 11:11 am
The column is not case sensitive. Maybe I should change the collation of the column?
CSDunn
quote:
Try making the Where clause:-WHERE UPPER(STREETNAME) <> STREETNAME
June 24, 2003 at 9:53 am
Thanks, that's what I was missing.
CSDunn
quote:
Remember to check that the field you are updating has changed. Perhaps on the EXISTS...
June 20, 2003 at 4:19 pm
Thanks, this is great!
quote:
Select Left(Address,Len(Address) - CharIndex(' ',Reverse(Address)))
June 19, 2003 at 10:21 am
Thanks to all, your input has been very helpful!
CSDunn
June 18, 2003 at 9:59 am
Hello,
The following is what I came up with, but the final average is still a little off:
*****************************************************************
Select
Permnum,
ROUND(
CAST
(
(
ISNULL((CASE When ST1Q1 <> 'N' Then CAST(ST1Q1 as tinyint) Else Null End),0) +
ISNULL((CASE When...
June 17, 2003 at 5:31 pm
Viewing 15 posts - 211 through 225 (of 250 total)