I just saw that same error myself this morning. The cause seems totally unrelated to the error, however. A user executed a stored procedure that contained a TRUNCATE TABLE statement....

You don't say where the error is occurring. However, you have two procedures that don't check for the existance of at least 1 row following a SELECT statement:

  Sub FillInGroupData()...

Many people have asked through this forum about a FORMAT() function. Unfortunately, you'll have to write your own. However, to get you started with the CONVERT() function, here are a...

By default, you cannot find the date of the most recent change.

I track the last date of change on a per row basis by adding a datetime column called 'dtchg'...

You could try using the DECIMAL datatype instead, although the internal storage requirements are much higher. Here's an example that maintains 4 decimal places. You can, of course, change that...

For mm/dd/yyyy format, use style 101:

SELECT Convert(varchar(10), GetDate(), 101)

SQL Server 6.5 does provide the CONVERT function. That function goes way back to early versions.

Anyway, try this example:

--drop table concatTest

create table concatTest

(

  cid int,

  myVarchar varchar(50),...

This code is a bit long, but should work as long as the HTML is each row is formatted as you previously specified. I think the key thing is that...

Maybe the following VB code will help. You could try to implement the FromHex and Encode functions in T-SQL.

The RFC for...

Look up BULK INSERT in Books Online. Make sure to read the section entitled "Copying Data From a Data File". About 3/4 of the way down that section it briefly...

How is the date being displayed? Through an application? That date format is not one of built-in formats, so maybe the appliction that is displaying the date is dropping the...

Jennifer,

Unfortunately, the only way I know of to accomplish what you want is to create the stored procedure in the master database, and begin the SP's name with 'sp_'. Then...

Why not just copy the table structure, without any data:

SELECT * INTO newtable FROM oldtable WHERE 1=2

Mike

Kristin,

Try:

UPDATE records

   SET chainpath = c.chainNumber

  FROM records r JOIN chains c ON r.specimenID = c.specimenID

or, since the query is simple, just:

UPDATE records

   SET chainpath = chains.chainNumber

  FROM records JOIN chains ON...

This probably doesn't address your connection problem, but your query should be:

select count(*) from postcode where postcode LIKE 'CT31%' 

Also, check this out:

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q229/5/64.asp&NoWebContent=1