Forum Replies Created

Viewing 15 posts - 12,001 through 12,015 (of 13,460 total)

  • RE: Is there a good way to understand the sysdatabases STATUS fields?

    4194840 = TORN_PAGE_DETECTION,OFFLINE,AUTOSHRINK

    528 = TORN_PAGE_DETECTION,OFFLINE

    my script from page one helps find the values, here's a snippet where i just plug in specific values:

    declare @status...

    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 6, 2008 at 9:39 pm

    #881420

  • RE: Trigger question

    jacob hit the nail on the head; chances are , if you can post the trigger here, we can show you how to re-write it so it handles multiple rows...

    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 6, 2008 at 9:38 am

    #881170

  • RE: Get two pieces of data out of one column

    I've only got the Express Edition, but the logic to get the data out should be easily adaptible.

    you want to use a CASE statemnt for each of the variables; "&",...

    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!

    September 28, 2008 at 3:05 pm

    #878207

  • RE: Changing the Server Collation Does not work

    like Glen said, changing the Server collation does not affect any databases, nor the individual columns that exist int he database...you need to handle those seperately.

    Server collation...

    each database collation...

    Each column...

    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!

    September 26, 2008 at 9:50 am

    #877808

  • RE: SQL 2005 standard edition and max. DB instances?

    found this specific citation; 2005 and 2008 have the same maxes for this

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

    SQL Server Database Engine object ...

    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!

    September 26, 2008 at 7:57 am

    #877702

  • RE: Query

    doh i didn't even see that CR might mean Carriage Return Line Feed...goodjob...

    Like Hanshi said, you might want something like

    REPLACE(TblC2.strAddr,'~~',CHAR(13) + CHAR(10)) as your expression

    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!

    September 26, 2008 at 7:42 am

    #877686

  • RE: Query

    are you looking fto simply REPLACE of ~~ with CR? or is it more complex than that?

    SELECT TblC1.Client AS Expr1, REPLACE(TblC2.strAddr,'~~','CR') AS Expr2

    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!

    September 25, 2008 at 1:20 pm

    #877300

  • RE: If data value has 8 characters, show middle six.

    it depends on what you want to do, of course....say that if it's 7 characters, do you you do anything at all? do you only strip off the first character,...

    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!

    September 25, 2008 at 1:12 pm

    #877288

  • RE: Creating a csv on the network from SQL job

    the issue you are running into is the account SQL server is running under is not an account that has access to teh network. jobs run under the security context...

    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!

    September 24, 2008 at 2:55 pm

    #876688

  • RE: Strip off first and last characters.

    a combination of using substring and a where statement will do the job; you might need to tweak the WHERE statemtn...are you sure it's only items that are exactly 8...

    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!

    September 24, 2008 at 2:15 pm

    #876672

  • RE: Converting Access SQL to MS SQL Problem

    i think the update is this:

    UPDATE TableA

    SET TableA.[Cap Code] = TableB.CapCode

    FROM TableB

    WHERE (((TableB.CapCode) Is Null) AND ((TableB.FromDate)

    Between [Effect Date] And [Term Date]))

    OR (((TableB.CapCode) Is...

    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!

    September 24, 2008 at 1:08 pm

    #876637

  • RE: Does SSMS have an 'Include COlumn Names in Results' Option for the Query Tool

    your too fast for me...once a path gets too many levels deep, i like screenshots too.

    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!

    September 24, 2008 at 12:05 pm

    #876577

  • RE: Does SSMS have an 'Include COlumn Names in Results' Option for the Query Tool

    yep it sure does: Tools>>Options

    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!

    September 24, 2008 at 11:58 am

    #876570

  • RE: Exec ActiveX from Update trigger on table

    avoid doing anything in a trigger not realted DIRECTLY to the data...an activex object could cause the trigger to rollback, or lock the table as the trigger waits for 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!

    September 18, 2008 at 12:04 pm

    #873820

  • RE: SQL Date range SUM

    I think something using BETWEEN would be my suggestion:

    AND d2.trade_date BETWEEN getdate() -730 AND getdate()

    or

    AND d2.trade_date BETWEEN '01/01/2007' and '01/01/2008'

    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!

    September 18, 2008 at 3:39 am

    #873464

Viewing 15 posts - 12,001 through 12,015 (of 13,460 total)