select 1 as myorderBy,name,salary from sometable where manager='Y'

UNION ALL

select 2 as myorderBy,name,salary from sometable where manager='N'

ORDER BY myorderBy,salary

it's all good; i just moved the WEHRE statment into a CASE so i could print a status:

SIGNING_DATEENTRY_DATETimeStatus

2010-05-01 00:00:00.0002010-05-04 00:00:00.000On Time Signing

2010-05-01 00:00:00.0002010-05-07 00:00:00.000On Time Signing

2010-05-01 00:00:00.0002010-05-10 00:00:00.000Exception Not within...

you can't without breaking referential integrity.

Otherwise you'd be dropping the foreign key constraint, or disabling the foreign key constraint so it would be invalid after you deleted the parent record.

maybe...

still the same idea, i think; for example the week of today is 22:

select datepart(week,getdate())

so biz day wise, m-f of this week is 22, m-f of last week is 21;

so...

pinky i guess the question is what do you want to do if the date is invalid?

return NULL?

SELECT

juliandate,

CASE

WHEN juliandate LIKE...

the problem with that is it will spawn an iexplorer instance, but not clean up after itself...after one hour, you'd have...

jared here's an example i think can show you the idea;

you want to use BETWEEN two dates, and use DATEADD to determin the range based on another date:

--results

SIGNING_DATEENTRY_DATE

2010-05-01 00:00:00.0002010-05-04 00:00:00.000

2010-05-01...

wrong tool for the job.

what are you trying to accomplish? is this a keep alive so your web page stays in the server cache?

what's wrong with calling iexplorer.exe from windows...

wrong tool for the job.

what are you trying to accomplish? is this a keep alive so your web page stays in the server cache?

what's wrong with calling iexplorer.exe from windows...

V in your first query of the UNION ALL you have this as part of the WHERE arguments:

CFA.ORGID IN ('*','SERVICE','4C0C6A2U7P','4X9A8F2U5A')

but in the second part of the union all,...

Baskar B.V (5/26/2010)

I am planning to write a trace to capture the trace for inserts/updates happening in sql-server tables across a server. Which event i should use to capture that?...

well i'd guess it was permissions of the service account running SQL, even though you said it's got permissions;

if you have xp_cmdshell enabled, you could see if this returns results,...

if i google Error 2147217900 , there are at least 4 different error descriptions related to that error number in the top 10 links i found...we'd need the error description...

but having credentials that are valid is the precursor to doing anything to each server.

so what if i know databaseserver.google.com exists, can i loginto it with a known username? can't...

well you gotta be sysadmin to add sysadmins...so can we assume you can login as 'sa' on every machine?

the easiest way would be to add your windows login to each...