Forum Replies Created

Viewing 15 posts - 7,111 through 7,125 (of 13,460 total)

  • RE: Is there a database which supports richtext features ?

    Madhu-207721 (7/21/2011)

    Dear,

    Is there a database which supports richtext features ?

    Scenario: I have a word template document with bookmarks.

    I have database which stores the data for the bookmarks and other...

    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 21, 2011 at 8:33 am

    #1356443

  • RE: Ingres Database Migrate into SQL Server 2008

    ananda.murugesan (7/21/2011)

    Mr.Lowell,

    thanks for reply..

    In SQL server 2008 server machine Not available Ingress ODBC driver 3.0 or 9.2 etc.. I think Ingress odbc driver required in Ingress machine only. Not in...

    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 21, 2011 at 7:15 am

    #1356354

  • RE: Ingres Database Migrate into SQL Server 2008

    ananda.murugesan (7/21/2011)

    Thanks for reply......

    Please tell me, how to transfer table and data to SQL 2008 from INgres database.?

    Does SQL 2008 DTS can able import table and data?

    Thanks

    ananda

    yes exactly. DTS (well...

    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 21, 2011 at 6:40 am

    #1356306

  • RE: Ingres Database Migrate into SQL Server 2008

    Procedures and functions(and triggers, if they exist) will have to be hand edited; there is no process that i've ever heard of that can convert procs and functions form...

    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 21, 2011 at 6:22 am

    #1356293

  • RE: Consecutive Blank Spaces in Data

    from a post by Jeff Moden, where he showed the sneaky way to get rid of multiple repeating chars in a single pass;

    this is replacing pound signs, but it should...

    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 20, 2011 at 3:09 pm

    #1356057

  • RE: query to change audit trace log size

    allamiro (7/20/2011)

    OK great thanks for the script it diffidently great

    However when you said the default is a so does that mean I will have 2 traces running ...

    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 20, 2011 at 3:06 pm

    #1356056

  • RE: query to change audit trace log size

    do you mean the default trace? for that, you can't, it's a black box...but you can script a copy of that same trace definition, modify THAT, and create a new...

    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 20, 2011 at 2:07 pm

    #1356010

  • RE: how to add commas as thousand separator for numbers stored as text

    check out Cast and Convert in Books online:

    http://msdn.microsoft.com/en-us/library/ms187928.aspx

    if your original datatype is money, then one of the overloaded parameters of the CONVERT function is to insert the commas like 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 20, 2011 at 1:43 pm

    #1355996

  • RE: T-SQL help on updating a table - perhaps (self updation?)

    first guess:

    Create Table #MySampleData

    (record_id int,

    ptno int,

    Account varchar(30),

    hosp int,

    batchid varchar(30),

    v1 varchar(30),

    v2 varchar(30),

    v3 varchar(30),

    v4 varchar(30), )

    INSERT INTO #MySampleData

    SELECT '22170260687','2217026','AB0706851265','39','G001OSX1','NULL','NULL','NULL','NULL' UNION ALL

    SELECT '22170261747','2217026','AB0706851265','39','G001OSX2','NULL','NULL','NULL','NULL' UNION...

    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 20, 2011 at 12:47 pm

    #1355954

  • RE: Removing or Replacing Data

    Ninja's_RGR'us (7/20/2011)

    What happens if the text outside the tags containt < or > ?

    I never fully tackled this problem, but I know it's far from simple.

    Moreover I think that RBARing...

    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 20, 2011 at 11:55 am

    #1355915

  • RE: Removing or Replacing Data

    ok here's a tested working example...that i reworked quickly because you changed the datatype tyo TEXT.

    i'm assuming this'll be a one time update, so it might be slow on 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 20, 2011 at 11:42 am

    #1355905

  • RE: Removing or Replacing Data

    i have this saved in my snippets for stripping out HTML tags. note this assumes that well formed html is in palce...so % lt ; should be there for <...

    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 20, 2011 at 11:17 am

    #1355886

  • RE: Complex multi-table joins?

    glad it helped a bit;

    i think of joins a stree branches...they can join on the trunk (base table) or join on a branch-of-a-branche that is attached to the trunk...however...

    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 20, 2011 at 8:43 am

    #1355696

  • RE: Complex multi-table joins?

    maybe an example might help?

    in my example below, i'm joining a bunch of two tables and a view agaisnt another table to get the desired data.

    my primary key columns, instead...

    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 20, 2011 at 7:28 am

    #1355586

  • RE: how to create maintenace plan in sql server 2008

    Your questions' a little unclear...do you not know how to create a maintenance plan, or are unsure of wether you can use a mapped drive?

    Your best bet is to simply...

    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 20, 2011 at 7:07 am

    #1355564

Viewing 15 posts - 7,111 through 7,125 (of 13,460 total)