:) That is exactly what you can do with .NET Remoting. Check out the articles as regards this subject on the codeproject and you'll find what you're looking for. There're are a lot of examples there.

Hi, maybe you should check out .NET Remoting via TCP or HTTP-channel. It would be the easiest and fastest way to build up a distributed application like the one you're about to create.

modified on Tuesday, November 24, 2009 9:19 AM

There's no problem in using a cursor within a while loop -> have a look at the MSDN, to review the example and you'll have your're problem solved.

Maybe you could have a look at the SQLDependency-class, too. It's another way to inform your app that sth. changed on a specific table in your SQL Server 2005 database.

I had to cast datetime-parameters to an nvarchar(50) to make the dynamic query work. Note: This had to be done within the query-string. I also had to specify the length of an varchar-parameter to make it work. Maybe this could help you, too.

simworld wrote:

RESTORE DATABASE student_database FROM XYZ WITH DBO_ONLY, NORECOVERY, STATS

You restore the database with the 'NORECOVERY'-option - this means that the database remains offline and in recovery-mode (normally used within database-mirroring). Remove this option and the first error-message should disappear.

How is your table called? p2? If p2 is the name of your table try the following update statement: UPDATE p2 SET p2.Attrib_code = p1.Attrib_code INNER JOIN p1 ON p1.lis_key = p2.lis_key WHERE Substring(p2.func_key,1,5) = 'GEOSS' AND P1.active = 1

Vuyiswa wrote:

Update sde.Property_Backup p3 set p3.Attrib_code = p12.Attrib_code

Why are you including sde.Property_Backup? If p3 is a table, it would be right to write: Update p3 set p3.Attrib_code = p12.Attrib_code.

In SQL Server you can get this value by using the global variable @@rowcount. The variable contains data about the number of rows affected by a sql statement and is updated each time you run a statement.

If your using SQL Server 2005 you could use the Day() / Month() / Year() - Methods to get the specified part of the date. I don't know exactly whether these functions are available in SQL Server 2000, too.

select count(*) from YourTable

select cast(5 as float) / cast(10 as float)

You could create a DataView-object for the DataTable via DataView dv = new DataView(ds.Tables[0]);. Then set the RowFilter with this line dv.RowFilter = "Site_ID = 5";

I'm not familiar using xp_sendmail- i only tried to send mails by using sp_send_dbmail. Did you try out this function? maybe you could use that one!

This works for me: SELECT g.Maximum, out_pumptable.posnumber from out_pumptable, (SELECT MAX(flow_lpm) as Maximum, posnumber FROM out_pumptable GROUP BY posnumber)g WHERE flow_lpm = g.Maximum group by g.Maximum, out_pumptable.posnumber

Add a Group by-statement to the very end of the whole query.

Add a top 1 for example to the first select-statement.

Sorry my fault, i copied the wrong string: This should be the right thing: SELECT g.Maximum, * from Projects, (SELECT MAX(col1) as Maximum, project FROM projects GROUP BY project)g WHERE col1 = g.Maximum

You're right - it has to be like that: SELECT g.Maximum, * from Projects, (SELECT MAX(col1) as Maximum, project FROM projects GROUP BY project)g WHERE MAX(col1) = g.Maximum

Try SELECT g.Maximum, * from Projects, (SELECT MAX(col1) as Maximum FROM projects GROUP BY project)g WHERE MAX(col1) = g.Maximum