HELP! How get user NT login

Hi,
I want to retrieve reports that use the Windwos authentication to filter
data linked to the user (e.g.: only sales for a specific user)
I tried to use a parameter which uses the property
system.security.principal.WindowsIdentity.GetCurrent.name,
It works fine when I run it from the designer, but when I deploy the report
on the ReportManager, I go an error:
Error during processing of 'login' report parameter.
(rsReportParameterProcessingError)
Any idea about this problem, or how to get the login by using another way?
Thanks,
StéphanieYou can use the built in RS parameter User!UserID.Value. This returns the
Windows login name, pre-Windows 2000 style.
If you need to strip of the domain name, I've written a post on how to do it
here
http://blogs.spipp.net/kaisa/archive/2005/04/15/255.aspx
Kaisa
"StephyB" <ssss@.zz.fr> wrote in message
news:%23GBha18zFHA.800@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I want to retrieve reports that use the Windwos authentication to filter
> data linked to the user (e.g.: only sales for a specific user)
> I tried to use a parameter which uses the property
> system.security.principal.WindowsIdentity.GetCurrent.name,
> It works fine when I run it from the designer, but when I deploy the
> report on the ReportManager, I go an error:
> Error during processing of 'login' report parameter.
> (rsReportParameterProcessingError)
> Any idea about this problem, or how to get the login by using another way?
> Thanks,
> Stéphanie
>

Help writing SQL

I want to select records where a column is null, is not null or is equal to a specific number. How do I do this in one sql statement. My application is an asp.net web site with a business logic layer, a data access layer and sql server. Thank you in advance.select *
from tb
where isnull(col,'*')=isnull(@.search,'*')

Help with UPDATE trigger

I am trying to setup a trigger that sends an email if a field is changed to specific data. The trigger works when ever the field is changed, but I only need an email if the field is changed to 'In Review'
Any help is greatly appreciated.

-- Create the trigger
CREATE TRIGGER reviewntc

--indicate which table the trigger is to be executed on
ON CltDue

--indicate that this an UPDATE Trigger
FOR UPDATE
AS

IF UPDATE(CDSTATUS)
BEGIN
--holds the changes
declare @.CDStatus varchar(40), @.CDClientName varchar (40), @.CDEventDesc varchar (40)
--grabs the data that we need
SELECT @.CDStatus = CDStatus, @.CDClientName = CDClientName, @.CDEventDesc = CDEventDesc
FROM inserted
declare @.rc int, @.mymessage nvarchar(4000), @.mysubject varchar (4000)
SET @.mymessage = N'The '+@.CDClientName+' "'+@.CDEventDesc+'" project has been changed to '+@.CDStatus+''
exec @.rc = master.dbo.xp_smtp_sendmail
@.FROM = N'sender@.domain.com',
@.FROM_NAME = N'sender',
@.TO = N'rcpt@.domain.com',
@.subject = N'A project has been changed to "In review"',
@.message = @.mymessage,
@.type = N'text/plain',
@.server = N'email serverl'
select RC = @.rc
END

goYou need to check for the updated value.|||I'm sorry, but I am new to SQL.
Where and how do I insert CHECK|||Got it.

I added an IF
Here is the code I have if anyone needs

-- Drop the trigger if it already exists
IF EXISTS(
SELECT *
FROM dbo.sysobjects
WHERE id = object_id(N'[reviewntc]') AND
OBJECTPROPERTY(id, N'IsTrigger') = 1)
DROP TRIGGER [reviewntc]
GO

-- Create the trigger
CREATE TRIGGER reviewntc

--indicate which table the trigger is to be executed on
ON CltDue

--indicate that this an UPDATE Trigger
FOR UPDATE
AS

IF UPDATE(CDSTATUS)
BEGIN
set nocount on
--holds the changes
declare @.CDStatus varchar(40), @.CDClientName varchar (40), @.CDEventDesc varchar (40)
--grabs the data that we need
SELECT @.CDStatus = CDStatus, @.CDClientName = CDClientName, @.CDEventDesc = CDEventDesc
FROM inserted
IF @.CDStatus = 'In Review'
BEGIN
declare @.rc int, @.mymessage nvarchar(4000), @.mysubject varchar (4000)
SET @.mymessage = N'The '+@.CDClientName+' "'+@.CDEventDesc+'" project has been changed to '+@.CDStatus+''
exec @.rc = master.dbo.xp_smtp_sendmail
@.FROM = N'sender@.domain',
@.FROM_NAME = N'sender',
@.TO = N'rcpt@.domain',
@.subject = N'A project has been changed to "In review"',
@.message = @.mymessage,
@.type = N'text/plain',
@.server = N'email server'
select RC = @.rc

END
END
go