Sysprocesses has the information you need in it when the trigger fires. You can get the information you need with a cross join since there is only 1 row in...

Because the case statement is wrong. The rows that say "In B" are actually "In A" and vice-versa.

should be

case

     when B.[START DATE/TIME] is null then 'In A'

     else 'In...

something like this:

declare @Foo table (

     dbkey int,

     dbdata varchar(10))

declare @foo2 table (

     dbkey int,

     dbdata varchar(10))

insert into @Foo values (1,'one')

insert into @Foo values...

<ctrl> + 0 will insert a null. Hold ctrl and press 0 key. Tab out of field to see the null.

Missed the parentheses around your in clause list.

(IIF( Fields!COST_ELEM_CTGY.Value IN "C", "P", "R", "V", "X"), "3OTHERS"),

should be

(IIF( Fields!COST_ELEM_CTGY.Value IN ("C", "P", "R", "V", "X")), "3OTHERS"),

Doesn't really stink. You can use any .NET compatible language to create your own custom tasks or data flow components.

VB.Net doesn't really have any serious shortcomings when it comes to...

Props to you Steve for doing the right thing.

Update UserName.CallLogRevenuesTEST set dateOnlyEnd = SUBSTRING( dateOnlyEnd, 9, 2) + '/' + SUBSTRING( dateOnlyEnd, 6, 2) + '/' + SUBSTRING( dateOnlyEnd, 1, 4)

Where CHARINDEX('2005', dateOnlyEnd) = 1

I thought question of the day was questions about SQL Server. Exactly how would anyone who does NOT have\use Litespeed know the answer to...

Interesting answer, but absolutely wrong. Creation of a temporary table, (either local # or global ##), results in the table being owned by dbo in tempdb. This is rather easy...

In addition to the fact (mentioned by chrismj) that this returns a reference to the object, not the value of the object, this particular call would return an error stating:

The...

I've been wrong before. I'll be wrong again.

The thing I dislike most, is when I'm right, yet "SOMEONE" thinks I'm wrong. Even though THEY are wrong, they have the power...

We use a packaged software application that is designed to be used differently by different companies. Their method of allowing customization for each company is to provide generic fields in...

Thank you for the clarification. Didn't know about getting points for submitting qod's.

I didn't answer correctly, because I failed to note the "SQL Server 2000 Standard Edition" part of the question. I don't like trick...