Forum Replies Created

Viewing 15 posts - 12,331 through 12,345 (of 13,460 total)

  • RE: Sql Problem

    oops don't crosspost. they handy recent posts option allows everyone to monitor all the forums, no need to place the same question in multiple places.

    follow the posts here:

    http://www.sqlservercentral.com/Forums/Topic408910-338-1.aspx

    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 10, 2007 at 6:46 am

    #740756

  • RE: Manipulating Integer8 (Active Directory)

    I don't know if this will help, but the big_int data type is 8 bytes in size, si it should be bign enough to hold the value; you probably already...

    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 10, 2007 at 6:43 am

    #740750

  • RE: extrememly complex query Anyone know how to do this

    if you could post the DDL for the table, and change the sample records to insert statements, we could help better; there's just no way to sort thru that copy...

    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 9, 2007 at 2:12 pm

    #740518

  • RE: extrememly complex query Anyone know how to do this

    in this case, you need to join the main table on itself.

    in order to do that, you need to use at least one alias; here's an example based on your...

    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 9, 2007 at 2:01 pm

    #740511

  • RE: Terabyte datacenter maintenance

    i don't envy you on the backup retore side of your job, but at the same time i do envy the extra large db features;

    I'd love the opportunity to learn...

    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 9, 2007 at 1:00 pm

    #740496

  • RE: Server Name

    addankireddyprasad (10/8/2007)

    Hi,

    If you are working on MS SQL SERVER 2000, You can update the master..sysservers table by enableing the sp_configure 'allow updates',1.

    update master..sysservers set srvname='New name' ,Datasource='New name' where srvid=0

    Regards,

    Reddyprasad.A

    MCITP

    Bad...

    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 8, 2007 at 5:51 pm

    #740203

  • RE: Update all empty cells to NULL?

    Steve Jones - Editor (10/8/2007)

    I'd use something like Lowell has to generate a script. Be sure it's hitting the tables that you really need. Last thing you want to do...

    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 8, 2007 at 5:41 pm

    #740201

  • RE: Update all empty cells to NULL?

    you could loop thru syscolumns and find all the varchars and such, and build a sql statement to run:

    select 'UPDATE ' + object_name(id) + ' SET ' + name +...

    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 8, 2007 at 3:18 pm

    #740174

  • RE: Update all empty cells to NULL?

    depends on what you mean by empty...chances are , it already is null, but it depends on the data.

    does empty mean an empty string?

    SELECT * from sometable WHERE somecol=''

    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!

    October 8, 2007 at 2:08 pm

    #740148

  • RE: Upgrade SQL 2005 Developers to Enterprise Edition

    you are correct, simply run the installation, but there is a caveat: Standard and Enterprise versions can only be installed on Server Version of operating systems...Win 2000 Server, Windows 2003.

    If...

    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 8, 2007 at 1:26 pm

    #740129

  • RE: Insert Trigger Behavior Change?

    can you post the trigger you are using for SQL2005? Also, could it be that you changed the trigger to After insert or something on 2005, when it was...

    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 8, 2007 at 9:18 am

    #740053

  • RE: EOL tag to ntext variable

    char 13 is a Carriage Return (vbCr) also known as

    char 10 is a Line Feed (vbLf) also known as \r (i think)

    in most PC based files, you'll find vbCrLf...

    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 8, 2007 at 6:44 am

    #739971

  • RE: Purchased software cannot connect to sql server

    much more likely to be a DNS issue i would think; since it appears to happen once in a while, and not 100% of the time, I'd venture the guess...

    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 4, 2007 at 1:23 pm

    #739296

  • RE: recursive sum for a general ledger balance

    the trick is to group by portions of the account number.

    this produces the results you were looking for:

    CREATE TABLE #Accounts (AccountNumber varchar(30), ParentAccountNumber varchar(30) )

    insert into #Accounts(AccountNumber ,ParentAccountNumber)

    SELECT '100-000-000',NULL ...

    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 3, 2007 at 9:37 pm

    #738925

  • RE: That annoying millisecond

    you could convert to int, which would be the number of days since the beginning of time(according to sql server that's 1900-01-01 00:00:00.000)

    SELECT getdate(),CONVERT(int, GETDATE())

    2007-10-03 23:07:05.640 ...

    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 3, 2007 at 9:08 pm

    #738920

Viewing 15 posts - 12,331 through 12,345 (of 13,460 total)