Forum Replies Created

Viewing 15 posts - 3,031 through 3,045 (of 13,460 total)

  • RE: Barcodes Code128 generator function

    take a look at teh script mister magoo built in this similar barcode 128b thread:

    http://www.sqlservercentral.com/Forums/Topic1470917-392-1.aspx

    with that and a bar code font, i think you would have everything you need

    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!

    July 30, 2013 at 6:57 am

    #1636961

  • RE: After insert trigger not firing

    your trigger is very close;

    inside a trigger, isntead of using @@identity, you wnat to use the virtual tables INSERTED (or DELETED, where approriate);

    that virtual table allows oyu to handle multiple...

    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!

    July 30, 2013 at 6:28 am

    #1636939

  • RE: Migrating System Databases Between Clusters

    i would disagree that restoring system databases is going to save you any work.

    I personally prefer to script out things like certificates, master keys, linked servers and logins, and jobs...

    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!

    July 30, 2013 at 6:09 am

    #1636931

  • RE: What's in your CLR?

    i have a big proof of concept CLR project that is filled with items i either create myself, or find here on SSC.

    I just keep adding to it as I...

    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!

    July 30, 2013 at 5:05 am

    #1636916

  • RE: Email to Mutiple users with different subject i.e Subject variable

    best_yunus (7/29/2013)

    Thanks a ton man.

    I modify this script according to me and it worked smoothely..

    🙂

    Superb..

    glad i could help; it's so much easier to take an example and adapt!

    enjoy!

    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!

    July 29, 2013 at 2:28 pm

    #1636768

  • RE: Generate job script from existing jobs

    there are dozens of scripts here on SSC for scripting out jobs:

    http://www.sqlservercentral.com/search/?q=script+jobs&t=s

    so from there you could then add a WHERE filter to any of those to limit to 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!

    July 29, 2013 at 12:37 pm

    #1636740

  • RE: SSRS - Sending Excel attachment & Body in same email

    i know i could do it via TSQL, with two separate queries.

    you could use a FOR XML to generate an html compatible BODY and a separate query for the sp_send_dbmail's...

    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!

    July 29, 2013 at 12:19 pm

    #1636732

  • RE: Limit when a trigger runs

    um, no.

    your if statement makes the trigger no longer support multiple rows.

    if i have, say five rows being updated, what row is this supposed to test?

    IF INSERTED.review = 0

    a great...

    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!

    July 29, 2013 at 8:57 am

    #1636679

  • RE: CAN ANY ONE WRITE QUERY FOR BELOW DESCRIPTION!

    margrests example returns a lot of false matches, becasue'ca' appears in a large number of values int hat string. searching for comma-space-CA was really the oinly way to do it...

    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!

    July 29, 2013 at 8:38 am

    #1636668

  • RE: Index Fill Factor

    performance typically has a lot more to do with

    1. the sarg-ability of the queries hitting the database,

    2. the accuracy of the statistics on the data and

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

    July 29, 2013 at 6:29 am

    #1636606

  • RE: Email to Mutiple users with different subject i.e Subject variable

    for individualized emails, i think you'll need two things:

    a cursor to go thru the list of email recipients, and which builds the custom subject/body

    sp_send_dbmail to actually send the email.

    do 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!

    July 29, 2013 at 6:09 am

    #1636600

  • RE: Point a newbie in the right direction Please!

    Thomas no sense reinventing the wheel; it sounds like you want to search for "free work order system" or "free support ticket system" and maybe include "sql" in it 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!

    July 26, 2013 at 3:08 pm

    #1636342

  • RE: Limit when a trigger runs

    dwilliscp (7/26/2013)

    Great.. how would this work with an insert? Would it execute? If so how would we wrap this in an IF statement to only run when updating the row.....

    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!

    July 26, 2013 at 1:14 pm

    #1636301

  • RE: Limit when a trigger runs

    that extra requirement is easy;

    we have to compare the INSERTED row to the DELETED row, and compare in a WHERE statement:

    WHERE INSERTED.[Comments] <> DELETED.[Comments]

    here's the trigger model again with...

    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!

    July 26, 2013 at 12:46 pm

    #1636287

  • RE: Limit when a trigger runs

    yep, that was because of the construction of your trigger:

    the [Document] = (select [Document] FROM INSERTED) would make the old trigger fail if more than one row was updated.

    my trigger...

    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!

    July 26, 2013 at 12:27 pm

    #1636277

Viewing 15 posts - 3,031 through 3,045 (of 13,460 total)