Forum Replies Created

Viewing 15 posts - 10,966 through 10,980 (of 13,469 total)

  • RE: Adding a tip to a hyperlink

    no, it's my ignorance John, sorry...

    I know the HTML way to get the desired action, but not how to do it via the Reporting Services Interface.

    I think Nate pointed you...

  • RE: Getting Full Text Search on another named instance.

    yes, you can uninstall FTS, and then re-install it;

    ive done that with FTS and reporting services; it doesn't break any other part ofg your installation.

  • RE: Getting Full Text Search on another named instance.

    If it is the right version, you'll need to rerun the setup. You can go to Add Remove programs and find SLQ express..the dialog would have a modify option so...

  • RE: Trigger/Stored Procedure Question

    i think something like this would work:

    CREATE TRIGGER TR_TEXT ON [uitgifteregel]

    FOR INSERT

    AS

    BEGIN

    IF EXISTS(SELECT [oaantal]

    FROM...

  • RE: how to create a trigger on attendance table

    no need to add duplicate posts if you didn't get the answer you were after;same question was asked here:http://www.sqlservercentral.com/Forums/Topic735615-145-1.aspx

    the more information you provide, the better we can help you.

    show us...

  • RE: write trigger for a table

    sagi (6/16/2009)


    write trigger for a table.i.e attendance table

    columns:emp_id,lunch_out_time,lunch_in_time

    suppose lunch_out_time=1pm

    in attendance table lunch out time should insert only after 1pm, should not insert before 1 pm

    plz send code very urgent thn'ssssssss

    duplicate...

  • RE: Track sql code on servers

    that's a good question.

    do a select * from sys.traces

    the first column, "id", is the traceid.

    with that value, you could stop and then delete the trace:

    assuming the traceid is 2,...

  • RE: Track sql code on servers

    a server side trace, rather than running profiler, is actually very light weight and has minimal impact.

    i personally use something like this, but it would rollover automatically based on size,...

  • RE: Bug in CHARINDEX ?

    isn't the patindex command like this, with % signs?

    select

    patindex('%http://www.blabla.com/tx/chrts/nln_lstngs/cnrg_ntrm-eng.html%', es_text),

    ES_TEXT

    from MultilingualText2

    CREATE TABLE Table_Text

    (Col1 TEXT)

    INSERT INTO Table_Text

    SELECT 'blah-blah' + 'http://www.blabla.com/tx/chrts/nln_lstngs/cnrg_ntrm-eng.html' UNION ALL

    SELECT 'other stuff in the textfield' + 'http://www.blabla.com/tx/chrts/nln_lstngs/cnrg_ntrm-eng.html'...

  • RE: Bug in CHARINDEX ?

    virgil i hope this might help: fiddling wiht TEXT fields is tough...here's a procedure i wrote to do find and replace in TEXT fields. I know this works on huge...

  • RE: Adding a tip to a hyperlink

    i think what you want is to add the "title" attribute to your a href tag.

    Click Here.

    looks like this:

  • RE: Convert RTF data

    wow i could make an article on SSC over this...lots of questions below got my thoughts flowing.

    VB6 can be used, but it was l8imited to 8000 chars due to the...

  • RE: How to redirect a port in sql server

    I'm not sure you have your arms around how SQL server uses ports.

    SQL server cannot listen to multiple ports. one port per instance default is 1433, as you know, and...

  • RE: Convert RTF data

    Oleg I'm glad you found a solution here. this thread started back in 2005, and has produced a lot of great ideas and solutions. people find it and it often...

  • RE: alphabetical vs. chronological order

    chburns (6/15/2009)


    I am having a problem returning records in sql. I am trying to retrieve the first record in a table (chronologically), but when I use a min function...

Viewing 15 posts - 10,966 through 10,980 (of 13,469 total)