Forum Replies Created

Viewing 15 posts - 9,481 through 9,495 (of 13,460 total)

  • RE: SQL Query Problem

    you had joined them, thought that's what you wanted;

    try a UNION ALL instead:

    Select

    Alias1.id ,

    Alias1.type ,

    Alias1.number ,

    Alias2.ID_NBR ,

    Alias2.PHONE_TYPE ,

    ...

    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!

    May 13, 2010 at 12:24 pm

    #1167127

  • RE: SQL Query Problem

    a slight variation on your original code; all i've really done is present more data, so you can see the changed columns;

    since you never showed the PHONE_NBR from the other...

    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!

    May 13, 2010 at 12:06 pm

    #1167115

  • RE: Team Foundation Server on SQL Server 2005

    restoration of items is something done from within TFS inteface in Visual Studio, and never at the SQL Server;

    i'm pretty sure this is the steps:

    in Visual Studio go to "Tools>>Options"...

    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!

    May 13, 2010 at 11:20 am

    #1167081

  • RE: Different Views depending on Roles

    well, i was looking at using the function is_rolemember(which returns 1 or NULL, not 1 or 0) and IS_MEMBER('af_developer'), but i think it finds explicit grants to roles, and 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!

    May 13, 2010 at 11:03 am

    #1167065

  • RE: function inside a stored proc - is this a bug

    I don't think you understand the security model;

    it is very common, for example, that an end user does not have any rights to tables, and all the operations occur only...

    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!

    May 13, 2010 at 9:22 am

    #1166995

  • RE: Free Advice or Free Consulting

    TheSQLGuru (5/13/2010)

    >>they're a last resort

    No, forums are NOT the last resort!

    TheSQLGuru is right! this forum is one of my first items on my list of resources!

    this...

    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!

    May 13, 2010 at 8:53 am

    #1166952

  • RE: Free Advice or Free Consulting

    I've been a member here for a while, and my skillset has matured in a large part because i answer questions here.

    I'd love to see my first 20 posts here...

    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!

    May 13, 2010 at 8:45 am

    #1166940

  • RE: How execute sp_OACreate ... without be sysadmin role member

    i think you could put the code in a stored procedure and use EXECUTE AS.

    as an admin, creat ea procedure with the work inside it like this:

    CREATE procedure pr_CallExternalProcess

    ...

    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!

    May 13, 2010 at 7:48 am

    #1166872

  • RE: Find all instances of SSRS in a domain

    wow that's a good question; i hadn't thought about auditing Reporting service instances....

    do you think it would it be enough to use something like SQLRecon to find all SQL instances,...

    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!

    May 13, 2010 at 7:23 am

    #1166857

  • RE: Free Advice or Free Consulting

    D.Oc (5/13/2010)

    Steve should ban those words (URGENT or IMMEDIATE HELP or NOW) to appear in the title.

    No! those are my favorite threads!

    "URGENT" posts are like a train wreck 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!

    May 13, 2010 at 6:41 am

    #1166805

  • RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

    there was missing commas and closing parentesis; Here is a syntactically correct verison of the above example, but I did not test ti to see if it worked:

    declare @my_root_nbr int

    set...

    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!

    May 13, 2010 at 6:32 am

    #1166797

  • RE: Keep table on the same page

    robert i've done this as part of the query before, but not as a feature of reporting services.

    for example, i knew that i wanted exactly five columns of data, 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!

    May 12, 2010 at 9:27 pm

    #1166610

  • RE: Purge the data from all the user tables in a database

    here's what i use;

    due to a naming convention, i know i can skip tables that begin with certain characters; you might have similar logic which designates which tables are lookup...

    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!

    May 12, 2010 at 11:49 am

    #1166432

  • RE: list of views in a table on a databse in sql2005

    run the procedure sp_depends; it will show all tables,views, functions and procedures that depend on your table;

    because of late binding on stored procedures, it is possible that a procedure has...

    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!

    May 12, 2010 at 6:59 am

    #1166163

  • RE: How to get sql server machine serial

    never heard of this locking code before today. it looks like a calculated value created by the program ecoid.exe.

    the program echoid.exe is not a Windows included executable, so of...

    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!

    May 12, 2010 at 6:08 am

    #1166122

Viewing 15 posts - 9,481 through 9,495 (of 13,460 total)