Forum Replies Created

Viewing 15 posts - 2,851 through 2,865 (of 13,460 total)

  • RE: Status Bar shows "Executing Query" but the result is viewed through other query windo

    karthik babu (12/3/2013)

    thanks for your interest...

    Please check the below code..

    set rowcount 40000

    Update T1 SET sName = t2.sName

    from dbo.t_table1 T1 INNER JOIN dbo.t_table2 T2 ON t1.tID =...

    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!

    December 3, 2013 at 7:12 am

    #1670379

  • RE: Storing Text Messages in a table

    lianvh 89542 (12/2/2013)

    Good Day,

    we use varchar(max) , and I also read Text is to be depricated . My concern is this : You'll have poor performing queries on this column...

    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!

    December 3, 2013 at 6:48 am

    #1670375

  • RE: Status Bar shows "Executing Query" but the result is viewed through other query windo

    karthik babu (12/3/2013)

    May be.. but I didn't use begin transaction to use commit.. should I include begin tran... end tran with commit..?

    Else that query will continue running indefinitely? :w00t:

    is 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!

    December 3, 2013 at 6:44 am

    #1670372

  • RE: Job Activity Monitor will not open -- reason?

    what version is your SSMS tool actually running?

    I've seen similar issues with the scripting of objects, where a prior version of SSMS cannot work correctly against a higher version...

    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!

    December 2, 2013 at 12:46 pm

    #1670212

  • RE: Restriction on Primary key

    LutzM (12/2/2013)

    Objection, your Honor!

    The physical storage on disk is based on the clustered index, which doesn't have to be the PK.

    sheesh, i know that, explained that lots of OTHER times,...

    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!

    December 2, 2013 at 12:25 pm

    #1670203

  • RE: Restriction on Primary key

    two primary keys, by definition, would be repetitively redundant 😀 if you think about it.

    essentially the primary key's main purpose is to be able to uniquely point to each...

    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!

    December 2, 2013 at 11:39 am

    #1670183

  • RE: Execute an sp for rows returned from a query

    rray 44280 (11/27/2013)

    I have a query that returns a bunch of rows. I have an sp that takes 3 of the columns in the query as parameters that I want...

    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!

    November 27, 2013 at 1:09 pm

    #1669569

  • RE: T-SQL Doesn't Catch Condition

    JimS-Indy (11/27/2013)

    It's a left join, so there will be I rows without L rows. In that case, I'm done, and need only one message ('Adding New PO Line to CPAS')....

    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!

    November 27, 2013 at 12:04 pm

    #1669550

  • RE: User unable to view stored procedure from Management studio

    for a single stored procedure, you would grant view definition on the User in the database(or the role/windows group)

    GRANT VIEW DEFINITION ON dbo.DelimitedSplit8K to ClarkKent;

    GRANT VIEW DEFINITION ON dbo.DelimitedSplit8K...

    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!

    November 27, 2013 at 11:51 am

    #1669546

  • RE: T-SQL Doesn't Catch Condition

    Jim i see the join critieria is this:

    LEFT JOIN tblPOLine AS L

    ON I.POID = L.POID

    AND I.POLINENUM =...

    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!

    November 27, 2013 at 11:35 am

    #1669542

  • RE: Is there any limitation of the way we perform concatenation in SQL server?

    you have to make sure ALL of your variables are the same (nvarchar(max))

    Truncation when concatenating depends on datatype.

    if you do something like this:

    nvarchar(max) + varchar(n)

    SQL will first convert 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!

    November 27, 2013 at 6:48 am

    #1669461

  • RE: comparing two string

    mailtoashokberwal (11/27/2013)

    Any suggestion on below:

    I need to compare two strings which have comma separated ISO Country codes.

    For example : String1 = '356,840'

    ...

    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!

    November 27, 2013 at 6:37 am

    #1669453

  • RE: is it possible to discern who created an object in a db like ferinstance

    if not too much time has passed, it will be in the default trace;

    but the default trace only keeps a rolling history of 100 meg, so it could get pushed...

    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!

    November 26, 2013 at 2:59 pm

    #1669276

  • RE: SQL 2000 - How long has a job (all steps inclusive) been running?

    ok, flexing my Google-Fu a little bit, i found this article that might help; it claims to find long running jobs in 2000-2008 versions:

    http://archive.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=AgentLongRunning

    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!

    November 26, 2013 at 1:51 pm

    #1669262

  • RE: SQL 2000 - How long has a job (all steps inclusive) been running?

    lptech (11/26/2013)

    Start with the sysjobactivity table, and you should be able to come up with something that fits your needs.

    I don't have a 2000 server to test agaisnt, but assuming...

    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!

    November 26, 2013 at 1:22 pm

    #1669256

Viewing 15 posts - 2,851 through 2,865 (of 13,460 total)