Viewing 15 posts - 661 through 675 (of 1,048 total)
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?
February 10, 2011 at 11:58 am
"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...
February 10, 2011 at 10:43 am
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...
February 10, 2011 at 10:16 am
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)....
February 10, 2011 at 9:06 am
Gary Herbstman (2/8/2011)
I know I can do it with a cursor but I prefer to stay away from them.
It can be done without a cursor. Try one of the approaches...
February 10, 2011 at 8:22 am
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...
February 10, 2011 at 8:12 am
you are calling it wrong. try: exec(@sql) or preferrably use sp_executesql
February 10, 2011 at 8:06 am
SELECT @sql = 'CAST( bulkcolum AS VARBINARY(max) ) FROM ' +
...
February 9, 2011 at 8:45 am
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
...
February 9, 2011 at 8:25 am
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...
February 9, 2011 at 8:22 am
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)...
February 8, 2011 at 10:42 am
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...
February 8, 2011 at 9:48 am
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...
February 8, 2011 at 9:14 am
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.
February 8, 2011 at 7:28 am
"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.
February 4, 2011 at 6:28 am
Viewing 15 posts - 661 through 675 (of 1,048 total)