SQLIS has plenty of examples for all types of transformations. You might want to take a look at the rowcount transformation examples.

Sure, what you have is:

,'TeamMentor' =

CASE

WHEN TeamMentorDate IS NOT NULL THEN 'Team Mentor'

WHEN (SELECT r.AchieveTitle FROM Repromotes r WHERE RepFlag = 'X' AND AchieveTitle = 'Team Mentor) THEN 'Team...

Yes - you can, but I am not sure you need this. Anyways, for that part - you can use an EXISTS, or check for NOT NULL. Examples:

CASE

...

Plenty of options and help at: http://www.sqlis.com

SQL Server uses the Windows password policy mechanism. So, whatever is defined on your server (Windows 2003 or higher) is what will be used.

midan1 (12/22/2007)

i ask the friends here if thay can help only !

i am working on complex project and i need it

to find the "day before Last day of...

With your SAN an HP EVA - single disk group with 120 spindles, it won't make any difference at all. All LUN's are presented from the same set of...

I would be very concerned about this approach, since you no longer have any way of restoring your system to a point in time prior to your latest backup.

Take this...