I'm wondering if both your tables might have the same column name DLOAN or TLOAN. If so, you need to fully qualify them -- TableName.ColumnName.

Eli

You can use the following query:

SELECT syscolumns.name, syscomments.text

FROM sysobjects, syscomments, syscolumns

...

Yes - the dataset is the query. However the actual SQL statement can either be placed directly in Business Intelligence Development Studio under the data tab or it can be...

There are plenty of tools out there that can compare differences in DB Schemas. They even have the ability to create scripts to quickly/easily sync them. I personally use Red...

Why don't you state that:

IF UPDATE(someColumn)

BEGIN

--code

END

This will only process if your desired column gets updated.

Eli

Sure - no problem. I think that the reason you may have been receiving 00 is because you had lower case mm which relates to minutes instead of months. If...

Try this:

=format(Fields!YourDate.Value, "MM - dd - yy")

Eli

What is the error that you are receiving?

You can bulk insert into a temporary table and then select the columns you desire. Here is an example:

DECLARE @TempTable TABLE

(

Column1 INT,

Column2 VARCHAR(10),

Column2 VARCHAR(10)

)

BULK INSERT @TempTable FROM 'Filepath'

SELECT Column1, Column2

FROM...

I definitely wouldn't have come up with Jeff's solution :-D. All I was saying is that I wasn't...

I know that a CASE statement treats each row separately -- that's part of the problem. Once the collumns are ordered, using the first given examples you will end up...

Not sure if this helps, but a possible work around can be to create another table instead of using text boxes. You can modify the border designs etc. on the...

Something like this?

CREATE TRIGGER TriggerName

AFTER UPDATE

AS

BEGIN

IF UPDATE (ColumnName)

BEGIN

DECLARE @cuartoid int

SELECT @cuartoid = ColumnName from INSERTED

EXEC ACTUPRECUARTO @cuartoid

END

END

Eli

Unless c1, c2, c3.. are intrinsically meaningless and are just data placeholders, then the case statement will just help the first record. Subsequent records will have to follow the determined...

Each row is one record. Therefore:

a) If you sort the rows under c1, it is impossible to also sort c2 and c3. This is even if you include all three...