Forum Replies Created

Viewing 15 posts - 13,306 through 13,320 (of 13,460 total)

  • RE: Enterprise Manager: Bug intoduced in SP4?

    EM is not a catch all edit all editor; it does a good job on many things, but not all things.

    making a grid that could allow the editing of 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!

    August 11, 2005 at 8:01 pm

    #581647

  • RE: always rounding down

    are you sure about the floor function returning an approximate number? the BOL says it returns the integer portion of the value, and returns it as the same data type.

    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!

    August 11, 2005 at 10:41 am

    #581484

  • RE: Query

    Phil's reply is spot on; exactly what I would have suggested for a specific date it identifies all projects open on the date passed in;

    and if you wanted to test...

    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!

    August 11, 2005 at 6:11 am

    #581354

  • RE: always rounding down

    yet another version:

    declare @m as money

    set @m = 200.2365

    select floor((@m * 100)) / 100

    results:

    200.2300

    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!

    August 10, 2005 at 8:35 am

    #581056

  • RE: Query

    I think you can assume that if getdate() is between a projects start and end date, then it is active; that's pretty straight forward.

    select * from projects where getdate() between...

    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!

    August 10, 2005 at 6:03 am

    #580965

  • RE: Finding a zipcode

    I'll tell you, i love this distraction; Scott's function works well, but I seem to get a much smaller result set than Dewaynes.

    I used this SQL to find items within...

    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!

    August 9, 2005 at 9:30 am

    #580781

  • RE: Finding a zipcode

    sorry; i wanted the conversion for the distance calculation to miles; the "distance" column is  a value, but i don't know what kind of units it's supposed to be.

    i don't...

    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!

    August 9, 2005 at 8:01 am

    #580727

  • RE: Finding a zipcode

    ok i have that same zipcode database , and this SQL seems to work:

    select  SQRT(POWER((38.492497 - latitude),-2)  + POWER((-121.404807 - Longitude),2) )  as distance ,zipcodes.* from zipcodes

    where SQRT(POWER((38.492497 - latitude),-2) ...

    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!

    August 9, 2005 at 7:45 am

    #580713

  • RE: arrays in store procedures?

    there's nothing wrong with using the IN operator and having only one item in the selection list:

    so if [#ABN_RUInput] only has one row witht he value 220056 , 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!

    August 8, 2005 at 8:38 am

    #580447

  • RE: Registering server

    additional instances must be identified by IP AND port numbernote the comma after the ip address)

     you should also be able to connect 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!

    August 5, 2005 at 10:35 pm

    #580222

  • RE: SELECT in Stored Procedure

    sounds to me like the decision to pull everything out into 4 tables was a mistake, since you need to query all 4 tables anyway. Is there a difference really...

    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!

    August 4, 2005 at 6:10 am

    #579513

  • RE: What does a restore do? What process does it follow?

    I'm under the impression that a lot of the backup time is SQL server finding/creating/reserving contiguous harddrive space;

    once it has the contigous space it goes pretty fast putting 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!

    August 3, 2005 at 6:33 am

    #579115

  • RE: Renaming an Instance

    instances can only be dropped; they cannot be renamed.

    uninstalling all versions of sql server, and then installing sql2005 will allow you to install sql20005 as the defaul instance.

    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, 2005 at 8:34 am

    #578200

  • RE: Is it possible to do the conditional count?

    By conditional counts i thought this is what you meant:

    select

    Count(ID) as TotalRecords

    case when isnull(Processed,0) = 0 then 1 else 0 end as RecordsNotProcessed,

    case when isnull(Processed,0) = 1 then 1 else 0...

    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, 2005 at 7:33 am

    #578172

  • RE: Query Error

    that was my point...the example i provided takes the '2A' into consideration by grabbing the substring of the first character, then you get your claim [version?] of '1' or '2'...

    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 27, 2005 at 9:59 am

    #577622

Viewing 15 posts - 13,306 through 13,320 (of 13,460 total)