Database

login as Administrator. and try. Vande Matharam - Jai Hind

I think the logic should be almost right, except a piece which I have a little doubt in the 'Where' condition in addition to my never-ending doubt on SQL CE, let me try it and give you the feedback of your code, Thanks @Michael Potter, your help is really appreciated, that is the last step regarding the database and I hope it could help on the objective desired.

DELETE [TableName] WHERE [TimeColName] < DATEADD(dd,-5,GETDATE()) AND [EmailColName] = 'No'

yes an SQL login can be mapped to more than one DB user. Picture an SQL login as an access to a building while a DB user provides specific access to rooms in the building. No access to the building (Login) then no access to the rooms (DB user).

It doesn't work like that around here. We don't just give out code. You should really try working on your own code and when you run into any problems with it, then ask. "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Hi Luc, Your 2nd code worked perfect for me, coz you're right for your assumption that when there's an equal maxima between these categories it will automatically sorted by category. Thank you very much. Regards, Hardz

messages wrote: Is it possible to create a database instead name of a database? No. It's a datasource configuration wizard. It's expected that database is pre-defined. Create your database from before and then configure it using the wizard. Sandeep Mewara [My last article]: Server side Delimiters in ASP.NET[^]

No, but you could have tables where you summarize various periods for future comparisons and such.

vvashishta wrote: I want to generate Excel Worksheet through a SQL Query fired on the table directly export data to an Excel Sheet. ..and? Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

It is free for commercial use; MSDN[^] wrote: SQL Server Compact 4.0 is freely redistributable under a redistribution license agreement and application developers redistributing SQL Server Compact 4.0 can optionally register at the SQL Server Compact redistribution site. Registering will help the developers in getting information about SQL Server Compact critical security patches and hot fixes that can be further applied to the client installations. Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

Where is the alarm going to be consumed, on the server! Why not have a trigger spit send an email via sql mail or write an app that send a text message. Most orgs either lock down the table so only authorised people have access or use email alerts. Never underestimate the power of human stupidity RAH

Let me put you put of your misery: SQL Wildcards[^]. Note the article is very general: you will still have to work out how to apply the information therein. "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me

Hello, A quickly lookup in google.com, I´ve obtained this information: INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\testing.xls;', 'SELECT Name, Date FROM [Sheet1$]') SELECT [Name], GETDATE() FROM msdb.dbo.sysjobs GO If you need more informtion, you can use this link: http://www.mssqltips.com/sqlservertip/1202/export-data-from-sql-server-to-excel/[^] Regards, David G. :-D

My bad for not seeing that you are updating, not selecting. Oops. Good to know that you have a solution.

Indeed it could. "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me

Which just reinforces my comment on the above thread, you have no idea what you are doing, get a book and do some reading on how databases work. Never underestimate the power of human stupidity RAH

jrahma wrote: [NullReferenceException: Object reference not set to an instance of an object.] rmconline.salary_slip.btnGenerate_Click(Object sender, EventArgs e) in C:\Users\Jassim\documents\visual studio 2010\Projects\rmconline\rmconline\salary_slip.ascx.cs:70 DevExpress.Web.ASPxEditors.ASPxButton.OnClick(EventArgs e) +96 DevExpress.Web.ASPxEditors.ASPxButton.RaisePostBackEvent(String eventArgument) +540 Running a debug build rather than a release build would yield actual file name, class name AND line numbers for where the exception exactly gets thrown; from there it is a matter of seconds to pinpoint the problem. :) Luc Pattyn [My Articles] Nil Volentibus Arduum