Forum Replies Created

Viewing 15 posts - 9,721 through 9,735 (of 13,459 total)

  • RE: How is this done ... or how would you do this?

    there is an article "zip code Radius search" that can help get you started:

    http://www.sqlservercentral.com/scripts/Miscellaneous/30878/

    it basically requires a table of postalcode/latitude/longitude, and finds all the records that match within the inputed...

    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!

    April 8, 2010 at 7:34 am

    #1148266

  • RE: mis-appying a cross apply table value function?

    I'll admit it, I'm weak on inline TVFs; had to look it up;

    i've saved a lot of Paul's recent code that was converting other's scalars to inline tvf's but my...

    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!

    April 8, 2010 at 6:08 am

    #1148170

  • RE: Databse mail sending blank mails

    you might be appending a null to the variable being used for the @body element;

    ie SET @body = @firstname + ' ' + @lastname + ' a bunch of info'

    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!

    April 8, 2010 at 5:07 am

    #1148137

  • RE: Local System Account on a share on different machine

    this is a common security issue.

    Because "Local System" never logs into a domain, it can never access a share. The logging into the domain is when permissions on shares...

    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!

    April 8, 2010 at 4:59 am

    #1148135

  • RE: mis-appying a cross apply table value function?

    Seth yes i had actual plan on, but even with it off it's still ~36 seconds;

    there's no space expansion or anything going on behind the scenes; i can run...

    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!

    April 7, 2010 at 7:59 pm

    #1147964

  • RE: Get DDL for any SQL 2005 table

    yeah i've used this code for a "schema checker" which compares a database to various xml docs;

    based on an internal table, if your db is marked "version 4" or...

    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!

    April 7, 2010 at 11:42 am

    #1147618

  • RE: COLUMNS_UPDATED in a trigger always return true for text datatype.how to find the text column actually updated or not??

    COLUMNS_UPDATED is very misleading; it returns true if the UPDATE statement happens to include the column in sql statement, not whether it's value changed;

    I believe since you cannot manipulate text/image...

    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!

    April 7, 2010 at 5:14 am

    #1147196

  • RE: Get DDL for any SQL 2005 table

    wow excellent catch David! I rarely work under multiple schemas, and certainly missed this!

    I've updated my code and previous links to have the correction you mentioned, and you can downloaded...

    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!

    April 7, 2010 at 5:03 am

    #1147192

  • RE: Restore Error

    i think i've seen this before, where version 539 is not a release-to-market version of SQL , but one of the preview versions.

    I had that issue where i could not...

    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!

    April 6, 2010 at 11:16 am

    #1146660

  • RE: Converting Image to varchar

    i've never scripted images out, mostly because they can't be represented in a string;

    this link might help you, but everything i've ever seen shows that you have to treat images...

    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!

    April 6, 2010 at 5:59 am

    #1146405

  • RE: order by

    you'd have to show us the sql statement...it's a simple syntax error, but we'd need to see the statement to help.

    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!

    April 5, 2010 at 9:49 am

    #1145806

  • RE: Are there alternatives to tempdb

    a new, seperate instance would have a greater impact on a machine than simply making tempdb starting with more than enough room to handle expansion needed by your apps calculations....

    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!

    April 5, 2010 at 9:41 am

    #1145799

  • RE: order by

    something like this? you can use a case statement in the ORDER BY for custom results.

    ORDER BY

    CASE

    WHEN YOURCOLUMN = 2 THEN 10

    WHEN YOURCOLUMN =...

    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!

    April 5, 2010 at 9:37 am

    #1145795

  • RE: Can we set session timout period Server 2005.?

    Joy i believe that is a function of the application that is doing the connecting...for example SSMS will wait forever, whereas any application that is creating an instnace 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!

    April 5, 2010 at 7:38 am

    #1145706

  • RE: Please unsubscribe me from all your mailings.

    ironically, since the OP posted to the forum, he gets another email every time we post to the thread,

    because he hasn't unsubscibed from the thread, which is different 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!

    April 5, 2010 at 6:34 am

    #1145666

Viewing 15 posts - 9,721 through 9,735 (of 13,459 total)