Forum Replies Created

Viewing 15 posts - 5,416 through 5,430 (of 13,460 total)

  • RE: Using the DelimitedSplit8k function - Help Jeff!

    in his example, at least one value was "1.5", so th3ey are not single character items.

    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!

    June 7, 2012 at 2:22 pm

    #1498411

  • RE: new to clr Integration,

    the error message is related to debugging.

    do you really need to debug the CLR?

    why not just deploy the project, then test it in q window for known pattern/values?

    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!

    June 7, 2012 at 1:19 pm

    #1498381

  • RE: schema changed after the target table was created. rerun the select into query

    i'm thinking it has to do with the target tables, and not anything to do with the temp tables;

    i read his comment as disabling reading data into temp tables,...

    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!

    June 7, 2012 at 7:22 am

    #1498147

  • RE: schema changed after the target table was created. rerun the select into query

    i thought the issue might be related to the altering of the indexes; that would count as a schema change.

    Some of which disable indexes and re enable them after...

    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!

    June 7, 2012 at 6:35 am

    #1498105

  • RE: Msg 102, Level 15, State 1, Line 2 Incorrect syntax near 'GO'

    don't allow a GO to exist inside the comments:

    WHERE #enr_detail.acc_nr = drsmas.drs_acc

    GO */

    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!

    June 7, 2012 at 6:03 am

    #1498085

  • RE: varchar(max) with QUOTENAME

    Boooks online says a the argument expects a varchar/nvarchar(128) for the max size.

    QUOTENAME ( 'character_string' [ , 'quote_character' ] )

    Arguments

    'character_string'

    Is a string of Unicode character data....

    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!

    June 6, 2012 at 2:06 pm

    #1497891

  • RE: Test PC is faster than Server Meachine

    did you rebuild the indexes or update statistics on the new server yet?

    this would be especially true if the database you restored came from a different version of SQL...the engine...

    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!

    June 6, 2012 at 1:33 pm

    #1497874

  • RE: How to list the version number of an assembly and in which database it exists

    you could query sys.assemblies;

    i'm sticking the results in a global temp table for ease of reporting, for example:

    CREATE TABLE [dbo].[##RESULTS] (

    [DBNAME] ...

    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!

    June 6, 2012 at 12:58 pm

    #1497859

  • RE: Calculated Columns - decimal

    you need to calcualte the counts, and apply the ROTT calculation to that;

    by simply wrapping the grouping as a subquery, this gives you what you are after:

    select @rott as ROTT,

    (count_of_referrals...

    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!

    June 6, 2012 at 12:37 pm

    #1497846

  • RE: decipher ReportServer.DataSource.ConnectionString

    try to see if it's convertable from binary to text:

    i don't have any reportingservices that are touchable to test:

    select

    CONVERT(NVARCHAR(max),CONVERT(VARBINARY(max),ConnectionString)) As ConversionAttempt,

    ConnectionString,*

    from ReportServer..DataSource

    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!

    June 6, 2012 at 11:25 am

    #1497781

  • RE: Calculated Columns - decimal

    Sql integer division: int / int =int, not the decimal you are expecting.

    Change @rott /100.0 and it should work as expected.

    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!

    June 6, 2012 at 10:34 am

    #1497747

  • RE: call executable with xp_cmdshell from procedure

    details are in order, i think.

    are you really just running 'dir d:\runtime\SomeExec.exe' (directory!) or are you EXECUTING 'd:\runtime\SomeExec.exe'

    how do you know "nothing" happened?

    what does the executable do?

    does it...

    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!

    June 6, 2012 at 7:06 am

    #1497602

  • RE: Your development/workstation laptop

    Microsoft indirectly butters my bread, so to speak, as I'm doing dev/web/sql stuff all in SQL Server and .NET technologies. All my coding efforts at work are on that platform.

    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!

    June 6, 2012 at 6:33 am

    #1497576

  • RE: oracle views

    alpeshchauhan (6/6/2012)

    yes i have question how i find the after make views in oracle, how i can see main view sysntex in oracle?

    pls help me.:-)

    the DESC (DESCRIBE) command 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!

    June 6, 2012 at 6:23 am

    #1497564

  • RE: oracle views

    did you have a question? you can edit your post to provide the missing info so we can 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!

    June 6, 2012 at 5:29 am

    #1497538

Viewing 15 posts - 5,416 through 5,430 (of 13,460 total)