Forum Replies Created

Viewing 15 posts - 3,706 through 3,720 (of 13,460 total)

  • RE: Create table Using the Structure and Data from the Dynamic SQL

    you didn't provide any real details or example code;

    without seeing the query featuring PIVOT, all i can offer is to use the SELECT...INTO TABLENAME FROM MyTable format.

    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!

    April 9, 2013 at 8:04 am

    #1604828

  • RE: Split data column with comma into seperate columns

    and another way, via a scalar function:

    /*--Results

    cellindex containerid containerlength istwincarry ...

    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!

    April 9, 2013 at 6:52 am

    #1604786

  • RE: When to update statistics manually, if at all?

    for me, it depends on the size of the table;

    for huge tables, it takes a lot less than 20% of the rows to make the statistics stale enough that they...

    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!

    April 8, 2013 at 2:22 pm

    #1604566

  • RE: Scalar function result into temp table column

    doug.davidson (4/8/2013)

    I have never explored a CTE before. Good new research and learning for me.

    I will use the sub select as the new work around until I finish my learning...

    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!

    April 8, 2013 at 1:51 pm

    #1604557

  • RE: Scalar function result into temp table column

    without re-writing the scalar function to be an inline table valued function, i though getting intermediate results for the scalar function in a CTE or sub select would be easier:

    i'm...

    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!

    April 8, 2013 at 1:37 pm

    #1604552

  • RE: SQL Server 2008 Link Server Connection Error

    172.17.15.100 looks like a public IP address, and not something on a private LAN;

    typically, external servers are locked down to ignore everything except port 80(http).

    if these servers are not on...

    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!

    April 8, 2013 at 12:30 pm

    #1604529

  • RE: How to NOT match on an exception list

    fantastic job providing the DDL and sample data!

    I think in this case, you need to match partial strings, right?

    you will want to join the tables together, but use a LIKE...

    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!

    April 8, 2013 at 12:24 pm

    #1604527

  • RE: Pushing Data from T-SQL to Visual Studio While Debugging

    mister.magoo (4/8/2013)

    Lowell (4/8/2013)

    I've done this a few times;

    here's a link to a slightly modified version of Microsofts Microsoft.ApplicationBlocks.Data SQLHelper.cs class, which i ran thru a converter, and then enhanced.

    SqlHelper.vb.txt

    Lowell, 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!

    April 8, 2013 at 11:36 am

    #1604514

  • RE: Pushing Data from T-SQL to Visual Studio While Debugging

    I've done this a few times;

    here's a link to a slightly modified version of Microsofts Microsoft.ApplicationBlocks.Data SQLHelper.cs class, which i ran thru a converter, and then enhanced.

    SqlHelper.vb.txt

    the usage is something...

    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!

    April 8, 2013 at 10:25 am

    #1604495

  • RE: Linked server

    adonetok (4/8/2013)

    I created a linked server and use it to select data from one server to another.

    Is there another way except for linked server which will do the same job?

    OPENROWSET...

    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!

    April 8, 2013 at 9:21 am

    #1604465

  • RE: Searching stored procedure for table name but ignoring comments

    per Brians request, here's a parameterized stored proc using the logic i posted above;

    there's some cleanup that should be introduced where im arbitrarily doing a REPLACE of vbLf with...

    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!

    April 8, 2013 at 8:55 am

    #1604451

  • RE: User interface

    i would call SSMS a developer tool, and don't think it's really a tool for end users to be working with; it doesn't have any place like Access does 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!

    April 8, 2013 at 8:32 am

    #1604439

  • RE: Searching stored procedure for table name but ignoring comments

    brian wow it's been a while since i saw this thread.

    Today, I actually do the same with regular expressions and a CLR; if that's an option, let me know and...

    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!

    April 8, 2013 at 8:08 am

    #1604424

  • RE: synonyms for table column

    Krishna1 (4/8/2013)

    if my table is customer having column col1,col2 ...

    in the select query i want all the developners to access it in the query as

    select customercode, customername

    from mycstomer

    instead of

    select col1,...

    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!

    April 8, 2013 at 7:48 am

    #1604408

  • RE: User interface

    and a bevy of images here:

    SSMS 2008 Images/Screenshots

    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!

    April 8, 2013 at 7:09 am

    #1604380

Viewing 15 posts - 3,706 through 3,720 (of 13,460 total)