Forum Replies Created

Viewing 15 posts - 3,151 through 3,165 (of 13,459 total)

  • RE: Partial match & Update

    DBA12345 (7/3/2013)

    Hi Lowell,

    Thanks for your pormpt reply. But i do have 1000 records to macth in both tables. So, we have to put all the thousand values in the way...

    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 3, 2013 at 1:24 pm

    #1629650

  • RE: query

    elee1969 (7/3/2013)

    manikanta1207 (7/3/2013)

    what is the query to select nth highest salary of emp table

    select MAX(Salary) from Employee;

    this really sounds like homework....

    anyway,

    the nth highest , ie the second or third, requires...

    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 3, 2013 at 12:34 pm

    #1629646

  • RE: Partial match & Update

    you are going to have to cleanup the data, it looks to me;

    in your example, using charindex, you only get a single match.

    unless you can guarantee the three letter abbreviations...

    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 3, 2013 at 12:12 pm

    #1629637

  • RE: system sp permission

    i think granting VIEW DEFINITION TO {USER OR ROLE} , in a specific database, will give access to all the system views like sys.tables, etc, but not grant read/update 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!

    July 3, 2013 at 11:00 am

    #1629623

  • RE: A question about replacing a character in a nvarchar

    i also found this old scalar function that uses a Tally Table to find and replace, based on the ASCII code...

    this actually does the replacements 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!

    July 3, 2013 at 9:47 am

    #1629596

  • RE: A question about replacing a character in a nvarchar

    ok, i've done something kind of similar,and easily adaptable..

    i'm guessing that, for example, you really want to replace any letters À Á Â Ã Ä Å with A, is that...

    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 3, 2013 at 9:15 am

    #1629570

  • RE: A question about replacing a character in a nvarchar

    well, nested REPLACE functions are extremely efficient, even if they are wordy and make your eyes cross when nested more than a couple of times.

    format them for readability, but 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!

    July 3, 2013 at 8:15 am

    #1629546

  • RE: Xp_cmdshell

    Jeff Moden (7/3/2013)

    Tara Kizer (7/13/2010)

    If you are using a VB application, then there is no need to use xp_cmdshell for this.

    Since I'm no VB expert but still very curious, how...

    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 3, 2013 at 8:06 am

    #1629543

  • RE: Get Employee Managers Manger Query

    also, i think you had your joins backwards...

    this seems to show me everything correct:

    /*SuperVisorManager1Manager2

    ramNULLNULL

    surehramNULL

    vimalsurehram

    */

    CREATE TABLE [#Employee](

    [EmpID] [int] NOT NULL,

    [EmpName] [varchar](50) NOT NULL,

    [SupID] [int] NULL)

    GO

    INSERT INTO [#Employee]...

    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 3, 2013 at 7:53 am

    #1629538

  • RE: Overhead on a NC index if the key fields are not updated during production.

    pretty sure SQLSACT is correct;

    part of the update process is updating the indexes that are affected, so when the transaction is committed, bit the data itself and the indexes...

    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 3, 2013 at 7:35 am

    #1629531

  • RE: Finding unused fields

    OUCH this is painful to even acknowledge I built this query, after seeing how dog slow it is!

    my thought is the command has to look something like this, for every...

    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 2, 2013 at 3:48 pm

    #1629307

  • RE: Monitoring Your Database with SQL Profiler

    * also the Database Engine Tuning Advisor creates a trace with a NULL path, as well.

    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 2, 2013 at 3:18 pm

    #1629295

  • RE: Monitoring Your Database with SQL Profiler

    also I'm pretty sure a profiler created trace does not have a path: so you can do check sys.traces as a quick sanity check, and that would tell you...

    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 2, 2013 at 3:15 pm

    #1629294

  • RE: Finding unused fields

    As usual Sean's got it covered; about all i can say is null columns or tables with zero rows, is missing / no data often doesn't mean the objects can...

    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 2, 2013 at 2:21 pm

    #1629273

  • RE: Help with contents of a script

    it's effectively a script which performs the same operations as this GUI menu "Shrink Files" in SSMS performs...the followup screen lets you select either the database file(s) or the log...

    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 2, 2013 at 12:18 pm

    #1629242

Viewing 15 posts - 3,151 through 3,165 (of 13,459 total)