Forum Replies Created

Viewing 15 posts - 4,006 through 4,020 (of 13,460 total)

  • RE: List sql servers, versions, SP installed in all the servers of environment.

    I'd go with the powershell as well, but here's one more alternative:

    I've used SQLRecon in the past, which is free and did the job for me, but was last...

    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!

    February 13, 2013 at 7:22 am

    #1587449

  • RE: Sorting Issue

    side note to mister.magoo: which SSMS add on is that that lets you group totals from the results grid?

    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!

    February 13, 2013 at 5:43 am

    #1587393

  • RE: Open Query for select

    CTE with variables? sure, it's just like any other SELECT statement WHERE SomeColumn = @Param is certainly valid; just declare the variables before teh CTE, adn make sure you end...

    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!

    February 12, 2013 at 2:57 pm

    #1587217

  • RE: Open Query for select

    newbieuser (2/12/2013)

    Thanks a lot Lowell. CTE works perfect. This sql is run within a loop in a program and it is causing performance issue.. I have created a topic(Remote Query...

    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!

    February 12, 2013 at 2:40 pm

    #1587206

  • RE: Sorting Issue

    UT excellent job with the DDL and sample data;

    does this give you the results you are looking for?

    SELECT

    ID,

    TTYpe,

    TTime,

    COALESCE(NULLIF(TFunction, ''), TStatus) AS...

    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!

    February 12, 2013 at 2:15 pm

    #1587195

  • RE: Open Query for select

    bah the above won't work because of the local table.

    divide and conquer is what you'll need to do i think.

    i would try to use a CTE that gets just 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!

    February 12, 2013 at 1:34 pm

    #1587185

  • RE: Open Query for select

    amybe...but the problem with open query is your command has to be a static string...no variable, or concatenation of stirngs plus variables are allowed.

    how would this worl for you:

    SELECT *...

    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!

    February 12, 2013 at 1:28 pm

    #1587184

  • RE: How to estimate how much time a script will run?

    at least viewing the estimated execution plan would give you a ballpark number;

    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!

    February 12, 2013 at 12:24 pm

    #1587165

  • RE: sp_ExecuteSQL View Creation

    it works for me fine when i use

    EXEC(@ViewStr)

    --or

    EXEC sp_ExecuteSQL @Statement = @ViewStr

    I don't think you need the parameters in the EXEC anyway;

    the string passed doesn't 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!

    February 12, 2013 at 9:13 am

    #1587067

  • RE: Attaching DB Question

    i believe that unless you have started your instance with trace flag 1807, the server can only attach databases that exist on local, and not network storage.

    the trace flag 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!

    February 12, 2013 at 7:07 am

    #1586996

  • RE: Exclude records from list where one record equals a particular value

    NineIron (2/12/2013)

    Here's an example list. I need to exclude this MRN from my query because it contains the value 250.

    MRN ...

    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!

    February 12, 2013 at 6:22 am

    #1586979

  • RE: Trying to select XML data for one tag from an text field and isn't returning the data I need

    davidsalazar01 (2/12/2013)

    Lowell,

    It's only one occurence (e.g.<DID>) in the XML and your right I only want the data between the tags. Would the samples you posted do the trick? ...

    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!

    February 12, 2013 at 6:03 am

    #1586966

  • RE: Fullbackup succeeded but no files in disk

    could the script be overwriting the same backup file with differnet databases?

    ie the db "Dictionary" gets backed up to C:\Data\Backup.bak, and then the database "SandBox" overwrites teh exact same file...

    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!

    February 12, 2013 at 5:45 am

    #1586959

  • RE: Trying to select XML data for one tag from an text field and isn't returning the data I need

    david the select statement you posted will find where the END tag begins...wouldn't you want the value between the <did> </did> tags?

    could the opening <did tag have attributes?

    is there more...

    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!

    February 12, 2013 at 5:33 am

    #1586954

  • RE: FTP Sites?

    You probably have all the links you needed now Jeff, I'm late to the party on this one, but here's one more:

    Project Gutenberg has a large number of ftp mirrors...

    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!

    February 11, 2013 at 3:23 pm

    #1586757

Viewing 15 posts - 4,006 through 4,020 (of 13,460 total)