Viewing 15 posts - 1,726 through 1,740 (of 2,171 total)
Somehow one or both of the table "FilesInDirectory" or "INTERFACEFILENAMES" has it's schema changed during execution.
April 3, 2007 at 2:53 am
What do stored procedure AB_FINANCIAL perform?
April 3, 2007 at 1:08 am
Not without more information from you.
I don't like to resort to my crystal ball...
April 3, 2007 at 12:41 am
Which line is producing the error?
April 3, 2007 at 12:28 am
ROW_NUMBER() is a SQL Server 2005 function.
I suggested that appraoch because this is a SQL Server 2005 forum.
April 1, 2007 at 10:35 pm
Which code? The first suggestion or the second suggestion?
April 1, 2007 at 1:34 am
You could at least have some decency to comment if our previous suggestions are to your satisfaction...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=355182
March 31, 2007 at 9:43 am
You could at least have some decency to comment if our previous suggestions are to your satisfaction...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=354311
March 31, 2007 at 9:43 am
March 31, 2007 at 9:40 am
Too bad!
The query does not guarantee that all values come from same record...
March 31, 2007 at 9:27 am
Try this!
-- Prepare sample data
DECLARE @Sample TABLE (Course INT, StartTime DATETIME
March 30, 2007 at 3:04 pm
I don't think so.
We can provide valuable help, and some insights, to point you in the right direction.
And that's what the others in this topic has done.
Now YOU have to...
March 30, 2007 at 2:02 pm
Yes, I know you want us to do your work for you.
March 30, 2007 at 1:30 pm
You only cheat yourself.
You will get a resultset of all records.
March 30, 2007 at 1:29 pm
Viewing 15 posts - 1,726 through 1,740 (of 2,171 total)