Forum Replies Created

Viewing 15 posts - 16 through 30 (of 40 total)

  • RE: multi-part identifier could not be bound

    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

  • RE: Computed Columns

    You can use the following query:

    SELECT syscolumns.name, syscomments.text

    FROM sysobjects, syscomments, syscolumns

    ...

  • RE: What is the relationship between datasources and datasets?

    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...

  • RE: Comparing tables

    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...

  • RE: RETURN - inside a trigger

    Why don't you state that:

    IF UPDATE(someColumn)

    BEGIN

    --code

    END

    This will only process if your desired column gets updated.

    Eli

  • RE: Custom date format problem

    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...

  • RE: Custom date format problem

    Try this:

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

    Eli

  • RE: Problem with datepicker in ssrs 2005

    What is the error that you are receiving?

  • RE: Inserting RAW Data to Table with selected columns

    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...

  • RE: Help Needed ???

    lmu92 (6/29/2009)... Would you mind showing how you'd do that? (just being curious)

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

  • RE: Help Needed ???

    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...

  • RE: Grouping Objects such as textboxes

    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...

  • RE: Execute stored procedure in AFTER UPDATE trigger

    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

  • RE: Help Needed ???

    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...

  • RE: Help Needed ???

    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...

Viewing 15 posts - 16 through 30 (of 40 total)