This should give you what you're looking for:

DECLARE @FISCALDATE DATE

DECLARE @ENDDATE DATE

set @ENDdate = '02/01/2012'

SELECT CASE

WHEN datepart(MM,@ENDdate)<= 6

THEN CAST ('01-'+'07-'+ cast((DATEPART(YY,@ENDDATE)-1) as CHAR(4)) as datetime)

ELSE CAST ('01-'+'07-'+...

Doh! I looked earlier and swore I couldn't find that SQL 2000 forum but at second glance, I've now located it..

Go ahead, Gail, shatter my dreams. 🙂

I was afraid of that..thanks.

Lowell (11/20/2012)

---

I've got an example of this in my snippets; I've added a last example at the end, which returns just what i thought you asked for: only the...

Alternately, you can read the entire list of files into a table, stripping out the 10001 portion into a numerical column (with a column containing the entire filename, of course)...

Ah, thanks Gail!

If I remember correctly, the Index name is unique. Do you really need to verify both the object AND table name? Couldn't you just make sure that the index name...

What's wrong with using the standard "IF EXISTS"....DROP INDEX....CREATE INDEX structure used so commonly?

Ninja'd by Lynn 😀

Could always set the source and destination to unicode.

Thanks, Lowell. That was my first reaction as well, to check the extended events as it really seemed like it should be in there but I couldn't find anything about...

Right, Lowell, that code will fire inside any DML trigger that fires but only inside triggers that contain said code. Is there an umbrella object in which it could be...

I wasn't trying to be sarcastic or anything. I think that there are several classes that encourage you to find the solution or get help online. Since we're going to...

Hey Lowell,

Is there a way to set that DBCC inputbuffer code on the database level so that when ANY trigger fires you can get the schema name, table name, trigger...

I often wonder if it would be helpful to put in a TSQL Homework section on the forums so students looking for help with the same section of class can...