SQL Server can provide the values you want using  DatePart ( dy, <date> ).

Try these examples:

declare @date datetime

set @date = '1/1/2003'

SELECT Convert(varchar(3), DatePart(dy, @date)) + '-' + Convert(varchar(4), Year(@date))

set @date...

How about something like the following (note that it is easier to use 'less than the first of the next month' instead of trying to figure that last day of...

Here's an example. Note that I changed the cursor to retrieve the column name instead of using a separate SET.

drop table tbl1

drop table tbl2

drop table autoinc

go

create table tbl1...

Click the Hammer icon in the upper left corner of the window, then click Customize View from the menu.  Make sure the the Toolbars checkbox is checked.

If that doesn't work, the...

Here's a link to the Microsoft KB article describing the procedure mentioned above:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;165918

If you don't care about resetting the rid values, I would just use something like:

(Assume table has two columns: rid int identity(1,1) and logtext text)

delete logs

 where rid in (select top...

How about something like the following? For simplicity, I used integer keys and left out error checking in the stored procedure.

DROP TABLE cars

DROP PROCEDURE pSwapCarDetails

GO

CREATE TABLE cars

(

CARManuf int...

How about this:

DECLARE @STORE_ID VARCHAR (10), @BUSINESS_DATE DATETIME

SET @STORE_ID = ''

SET @BUSINESS_DATE = '06/30/2002'

IF @STORE_ID <> ''

BEGIN

SELECT STORE_ID,

BANK_CODE,

...

quote:

---

There is also a script here that can help

http://www.sqlservercentral.com/scripts/contributions/26.asp

Steve,

I use SQL Server 2000, and that code doesn't work. For example, dbcc loginfo...

For this type of problem I typically use a UDF. The one I'm providing here will return a table for each record. If you are only using it for a...