Forum Replies Created

Viewing 15 posts - 12,271 through 12,285 (of 13,460 total)

  • RE: How to dynamicaly exclude chosen ID in SP for the next run?

    you'll have to save the winners in a table somewhere, in order to exclude them.

    create table PreviousWinners(id int, Sample varchar(10))

    select T1.ID,T1.Sample,MAX(RND) from T1,

    Left Outer Join PreviousWinners on T1.Id=PreviousWinners.Id AND T1.Sample...

    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!

    October 18, 2007 at 8:27 am

    #743146

  • RE: Auto Column Check

    i don't think you can use a calculated column in this case, because the penalty amount resides in a different table(P as Penalty Table) than the items that determine the...

    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!

    October 18, 2007 at 5:50 am

    #743079

  • RE: Cipher Blowfish enctyption, decryption

    no i don't think your missing anything; an encyption method is a style to do it back and forth, but the actual implementation is not going to be the same...

    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!

    October 18, 2007 at 5:07 am

    #743065

  • RE: Cipher Blowfish enctyption, decryption

    The DBA Toolkit found here on SqlServerCentral includes an extended stored procedure for the blowfish encryption method:

    http://www.sqlservercentral.com/articles/Security/sql2000dbatoolkitpart1/2361/

    you could give that a try; it may or may not work; for example,...

    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!

    October 18, 2007 at 4:28 am

    #743057

  • RE: how to remove numbers from strings?

    you forgot the single quotes...

    IF @TmpString NOT LIKE '[0-9]'

    or if it was part of a large string, you'd add percent signs for the wildcard matches:

    IF @TmpString NOT LIKE...

    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!

    October 17, 2007 at 9:05 pm

    #742968

  • RE: How to Trim a Memo field?

    can't you test with two clauses in the WHERE statement for a match, and also that it doesn't have the trailing word after it? you need to take the spaces...

    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!

    October 17, 2007 at 7:37 pm

    #742948

  • RE: variable query question

    Luke identified that it's no problem running it concurrently.

    i call it ugly search becauuse it's not something you want production users to use, and image you have a 12 million...

    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!

    October 17, 2007 at 2:12 pm

    #742880

  • RE: variable query question

    this might help;

    i create a proc i called "uglysearch" which searches every varchar,char,nvarchar and nchar column for a string.

    it returns the table and column, as well as the sql to...

    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!

    October 17, 2007 at 1:19 pm

    #742861

  • RE: T-SQL Code Bank

    there's no builtin search specific to the cliptext window, but the file of snippets you collect is saved in the \EditPlus 2\ folder as a text file ending in .ctl,...

    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!

    October 17, 2007 at 11:11 am

    #742822

  • RE: How to Trim a Memo field?

    hope this helps...this is the model i use for find and replace in text fields.

    in this case, the sample is replacing a relative HTML link witha full http: link,...

    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!

    October 17, 2007 at 5:21 am

    #742660

  • RE: How this query could be improved?

    can you paste the query as text here as well? it helps to be able to see that as text and not as an image in order to help better.

    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!

    October 16, 2007 at 12:54 pm

    #742476

  • RE: Tracking changes made thru EM

    lol encrypting is a good answer. way to go!

    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!

    October 16, 2007 at 10:30 am

    #742442

  • RE: Creating insert statements for posts (DDL - DML)

    there's an excellent stored proc called sp_generate_inserts Written byNarayana Vyas Kondreddi

    http://vyaskn.tripod.com

    he's got one for 2000 and 2005 and it generated statements like...

    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!

    October 16, 2007 at 10:29 am

    #742440

  • RE: How to Pass table valued function values to stored procedure

    you can use the table value function as a joined table or as an in() statment as well, if it's not obvious: i used a #tmp table,b ecause you might...

    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!

    October 16, 2007 at 7:18 am

    #742344

  • RE: String Manipulation

    i think what you are asking for is exactly what full text indexing actually does.

    it creates the word list for you, maintains an editable list of noise words, and handles...

    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!

    October 16, 2007 at 5:07 am

    #742278

Viewing 15 posts - 12,271 through 12,285 (of 13,460 total)