Statement below does it "in one".  The part shown in red is the date to convert to the format you want. Change the whole of the portion shown in red by...

Another couple of ideas ... but certainly not the "nicest" way to do it, and definitely not suitable for anything but "smallish" tables.

1. Query Analyzer can have the output directed...

You've reminded me of another issue, one which I learned very early in my career - which was in the days when storage was an issue (programming for an IBM...

First a caveat - variable type float only has 16 digit (or so) precision (corresponds to a 6 byte mantissa).  Even worse, decimals are not stored precisely as typed as...

Yes, but the question asked was to find a nominated string in ALL procedures.

Better technique may be to use Enterprise Manager to create a script which generates all stored procedures.  Save this file, then use standard searching methods.  When text is stored in...

Apologies for the very late reply ... monitoring this forum is not at the top of the priorities for my job.  There is a switch on the xp_sendmail command that...

I agree too ... and also suggest adding a datetime column so that you can purge the data after a suitable period.

Logic I've used is (and it works with multiple...

Ain't date handling marvellous?  All sorts of ways of "skinning the cat".  My approach to getting the first day of the month and first of the next is as follows...

First reaction ... don't insert the null (it is superfluous) .. ie

insert into APPROVAL (CODE_ID) VALUES (@Code_Id)

Isn't 01 Jan 1900 the base time & date for smalldatetime?

However, I tested some...

Saw the replies about INFORMATION_SCHEMA and went looking for the views.  Couldn't find them anywhere!  Then went and had a look in a little test database on my computer (set...

Your say the credit note shows the original invoice - only one condition ....

"the table keeps the invoice nr on which the credit note is made (field:fi.fnoft)"

Your select has two...

Sounds a rather nasty type of job.  Haven't tried anything like that ... but here's something that might help.

Imagine you would have to get the data into a temporary table...

Open Enterprise Manager and use SQL Server Agent to schedule a job to do the update.

Any other suitable scheduler running on an application server which connects to the database can be...

I remember seeing that problem a few years ago, and am having no luck trying to find it again.  My guess is that it is might be in SQL*Server 7...