Forum Replies Created

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

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

    i just re-wrote it as well, but the math is quite not right; i'm basically using multiple CTE's to do the intermediate variables as columns, as soon as i have...

    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 8:10 am

    #1148300

  • 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

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