Look at the modification dates... only one will current. The other is a left over from a previous installation or perhaps you have two instances on the same hardware?

"Drop your absurd “GradeLookupTable” which violates ISO-11179 rules by having “table” in a table name. I am also surprised you had one student and not more – that is what...

I am thinking your issue is that the PercentRecon column is an integer???

When you divide by sumofvisits you will get a value less than 1, unles they are equal...

You can specify the protocol in your connection string - for a local instance you can use shared memory instead of TCP/IP (in fact That is recommended for local instances)....

It can be done without a cursor. Try one of the approaches...

that seems perfectly normal to me. Your application needs to smart enough to handle the fact that SQL server may not be available for any number of reasons, but most...

you are calling it wrong. try: exec(@sql) or preferrably use sp_executesql

SELECT @sql = 'CAST( bulkcolum AS VARBINARY(max) ) FROM ' +

...

franck.maton (2/9/2011)

You could use a trigger for such a job:

CREATE TRIGGER CustomerUpdateMail

ON YourTable

FOR UPDATE

AS

declare @recordContent varchar(200)

declare @body varchar(2000)

SELECT @recordContent = recordContent

...

Yes, of course it is possible. Is it practical? ... that depends upon the volume of the new rows and the design and implementation of the mechanism.

In the simplest sense...

In the simplest sense you need to construct a single record from two separate records.

One way to approach it would be to group each (A records and N records)...

see if "labview" allows you to use a different driver (specifiy a connection string, or in a DSN). install and use SQLNCLI10. Also, id you can configure the connection...

What type of clients and what type of driver are they using? If they are not .net you should upgrade to SQL Native client 10 (SQLNCLI10). The clients...

you must be one of the fortunate few that actually get to set and enforce some standards, or at least have some influence on certain standards.

"Thank you all of you I've solved my problem by myself with this query."

I knew you could do it if you just gave a try son.