James,

--------------------------------

Quote:

My hero on this point is Harlen Ellison. He had the nerve when a person threw their cigar out the window at a curb to toss it back into their...

For control of flow:

IF 1 = 2 --criteria here

Begin

SElect '1 is equal to 2'

END

Else

Begin

select '1 is...

It depends on the functionality you want. how to handle non-numberic values. Coondapoor's function will trim all non-numberic values off the end of the number, but will leave...

That function is still not deterministic, though.

I've been playing around with this, but I can't get a "Get current date" function to be deterministic.

if object_ID('SystemDate') is not null...

Or, to bum it 🙂

If object_ID ('TableName') is not null

DROP table TableName

sairah,

It looks to me like you're having syntax issues. 🙂

To Alter a table:

alter table test add company_name varchar(8)

GO

To Insert to Table:

insert tablename (company_code)

select company_code from junk

1) Use the "GO"...

This is just a thought, but do you really want the clustered index on the identity column? I know this is standard, but a lot of times there's a...

----------------------------------

quote: Creating a composite index will not work in my situation. This is becuase those three columns are in the Where clause of three different SPs.

--------------------------------------

I still don't...

You may be better off using a composite index on all 3 fields instead of 3 indexes.

I would agree with jpipes that indexes are not going to help you much...

sairah, I'm not to familiar with Oracle...is it the "convert" syntax that's the problem?

Regarding group by: You must have a 1 to 1 relationship for all records in a...

I've seen this sort of thing before, and I don't know if I like it that much. You'll get these delete errors, but then the 2nd time you run...

This will group by day no matter what time is in datetime.

SELECT

cast(convert(varchar, DATE_TIME, 101) as datetime) as DATE_TIME,

MAX(QUANTITY) AS MAX_QUANTITY,

MIN(QUANTITY) AS MIN_QUANTITY,

AVG(QUANTITY) AS AV_QUANTITY

FROM TRANSACTIONS

group by cast(convert(varchar,...

Congrats, Frank. EOTM, huh; good stuff. Hope they gave you a phat bonus.

Tonight I'll barbecue a bratwurst in your honor. (that's German, right? 🙂

Don't create the table from within DTS. copy the "create" script and run in Query Analyser. Then you can just choose the table; shouldn't have any problems that...

That is a really sweet query...didn't realize it was as easy as joining on parent_obj.

Someone should post this...cnichol4?

select t.name as tablename

, c.name as columnname

, isnull(p.name,'''') as ConstraintName,

case p.xtype

When 'PK'...