Thanks John,

That was just what I needed!

Hi,

I hope you mean that the date is dd/mm/yyyy?

If that is the case, this should do the trick:

select [stats].[type], [stats].[machine], [stats].[tmestamp], [stats].[svalue]

from [stats]

where convert(nvarchar(10), [stats].[tmestamp])

=...

If you are:

1. Certain that no other processes may cause concurrency problems, and

2. Certain that you can create a recovery procedure that discovers whether anything has gone wrong (and...

Sorry, didn't see that one. Just delete the "as Delete" part of the statement, and it should work fine.

Do you get an error message at any point, or is it based on the data quality that you're able to say that something has gone wrong?

My first suggestion would...

Hi,

A couple of changes should do the trick:

CREATE PROCEDURE zipcode_distance

@ZipStart nchar(5),

@ZipEnd   nchar(5),

@Distance real=0 out -- Define an output-variable, and initialise it.

as

... -- Include your procedure...

Hi,

You'll need to add a parameter definition to the sp_executesql, as well as the variable that should be assigned the return value. A small example:

declare @stmt nvarchar(4000), @result...

Hi,

I agree with Capri and Osoba on this. It should work - we're using this in several procedures. However, I noted a typo in both their examples - @tablename should...

Unfortunately there is no (at least easy way) of doing this. There was an article about it some time ago:

http://www.sqlservercentral.com/columnists/ajethva/capturingtheerrordescriptioninastoredprocedure.asp

I agree - this is a bad idea. You will be restricted from doing a lot of things that you might like to do at some point. Dropping and recreating...

Hi,

Seems to me you're almost there. If I understand this correctly, you will always have a column called "DeviceID", that uniquely identifies a row in all tables? If this is...

Thanks Aaron,

I think your explanation makes sense, and it does seem to be supported by your examples. As I said, this was not an urgent problem, but I got very curious about...

The problem is most likely the order-by-clause. Templeton gave an explanation to this in this post:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=134851#bm134903

One possible work-around might be to insert the records into variable @mkfile1 using...

I have no general help for convertions in 6.5, but I believe they had the str-function at that time. Worth a try, anyway:

declare @my_int int

select @my_int = 12

select 'There are...

Something like this might do the trick:

SELECT datename(month, BillingDate) + ' '

       + datename(year, BillingDate) AS 'Calendar Month',  

       SUM(Quantity) AS 'Hours',

       SUM(AmountRemaining) AS 'Amount Billed'

  FROM ppa_Billings

GROUP BY...