Please tell us what you want the select statement to do. Do you want to display range? If so then it has to be in Select Clause not in "Having"....

Eddie is right Unicode doesnot affect DateTime field. If you want date to be displayed in different format use Conver function

Thanks

Sreejith

If you store this in a column thats datetime you will have 1/1/1900 as the Datepart.

Thanks

Sreejith

If you just want the time part or just the date part to be stored then you need to make that column it a varchar or char column. If you...

Can you create triggers on the table and store audit records in Audit table? If so then that should solve your problem.

Thanks

Sreejith

The way we've set up auditing is to Create a local windows group and put Global group (which has all the domain users) and grant the loacl group execute permission...

If the job doesnot send emails then do u know what account starts the SQL Agent and can that account send emails?

Hope this helps.

Thanks

Sreejith

If its SQL backup have ever tried SQL Maintenance Jobs cos u can set it to back up and delete backups that are older than any number of days that...

You should always try avoiding cursors. And here is how u can do it.

select tblExtract.fintCostCentreID, tblExtract.fvchProductFamily,

 '80000165' as [Schedule], (sum(tblExtract.fdecHours) / fintCostCentreIDHours.fltTotal) * 100 as [Value], ftntPeriod, fintYear

 from tblExtract INNER...

Can you please explain the problem with giving us the code?

Are you trying to display RCONE if row count is 1 and RCTWO if its greater than 2 (How...

Create a NT User Group

Assign the application users to the NT User Group

Create login in the SQL for the NT User Group and grant access to the DB

Grant execute on...

Assuming a Customer can have multiple accounts and accounts have multiple xaction its 1 to many Customer to account and 1 to many accounts to Transcation.

To use multiple files I would take the "Copy Excel" out of DTS and into stored procedure as xp_cmdshell. In the SP the process will loop through and copy the...

Good Catch..Didn't think about it.

Thanks

Sreejith

POP or SMTP SQL Sends mail using xp_sendmail. But that assumes you've set up SQL Mail properly.

You can also use CDONTS in ActiveX script.

Thanks

Sreejith