Forum Replies Created

Viewing 15 posts - 10,951 through 10,965 (of 13,460 total)

  • RE: increment child records based on parent id

    your'e trying to use an identity() column in the wrong way; an identity should simply identify one row as unique, and should never repeat...what you want is basically a ranking...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 19, 2009 at 8:13 am

    #1012419

  • RE: How to Access content of a file from different server using stored procedure

    it can be done yes...but it's going to involve a bit of work. search for "FTP" on this site, and look at "Scripts" ; there s quite a few contributions...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 19, 2009 at 7:55 am

    #1012404

  • RE: Way to delete/add entries to Microsoft® SQL Server™ log file

    GilaMonster (6/19/2009)

    You wanna maybe tell me why you want to remove an entry from an error log? The main use I could see for that is to hide evidence of...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 19, 2009 at 7:19 am

    #1012373

  • RE: How to Access content of a file from different server using stored procedure

    'ftp://username:password@xx.xx.xxx.xxx/domainname/www/textdocument.txt' is not a static filepath..., you have do download the file from your ftp site to a location on the server(or maybe in anetwork share if your account...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 19, 2009 at 7:05 am

    #1012360

  • RE: Select * into table with a stored procedure?

    it might be that you need identify the columns to insert into:

    INSERT INTO DatabaseReport.dbo.Database_File_Info(col1,col2...)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 19, 2009 at 12:43 am

    #1012197

  • RE: DML triggers in SQL Server 2005 Express

    did i misread the question? i thought he wants audit triggers to write to a separate database,and didn't see where anything about a separate server.

    I thought it would be a...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 18, 2009 at 8:04 am

    #1011768

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 17, 2009 at 9:34 am

    #1011071

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 17, 2009 at 8:26 am

    #1010971

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 17, 2009 at 8:11 am

    #1010954

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 17, 2009 at 7:07 am

    #1010885

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 17, 2009 at 5:20 am

    #1010784

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 17, 2009 at 5:19 am

    #1010783

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 16, 2009 at 3:07 pm

    #1010511

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 16, 2009 at 10:58 am

    #1010344

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 16, 2009 at 10:19 am

    #1010322

Viewing 15 posts - 10,951 through 10,965 (of 13,460 total)