Forum Replies Created

Viewing 15 posts - 7,456 through 7,470 (of 13,460 total)

  • RE: Best way to separate "stacked" records

    well based on your data, see what this does for you:

    it's assuming less than 10 on the quantity, but it's close;

    the assumption of 12 char descrip doesn't work 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 3, 2011 at 3:30 pm

    #1333959

  • RE: Best way to separate "stacked" records

    kinda fun guessing for now:

    assuming you inserted the data into a table with an indeity, i'm joining on found rows to get the price;

    it also looks like the descriptiuon 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 3, 2011 at 2:26 pm

    #1333933

  • RE: Error: 18456, Severity: 14, State: 38. - Specified Database - Any way to find out WHICH Database?

    ahhh ok; definitely more helpful;

    State 38 is:

    Reason: Failed to open the database specified in the login properties.

    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 3, 2011 at 1:44 pm

    #1333906

  • RE: Best way to separate "stacked" records

    if you only need the UPC, it looks like you could search for the # sign, and either a space or the end of the row.

    this example SEEMs to work...

    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 3, 2011 at 1:37 pm

    #1333904

  • RE: Exception 155, sev 25 when restoring backup of 2005 DB to 2008

    bhoff (6/3/2011)

    yeah, I was just thinking about that. The configurations for each are identical in the "HyperBac Configuration Manager", so I don't see how it could matter

    i don't either, 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!

    June 3, 2011 at 11:37 am

    #1333840

  • RE: Exception 155, sev 25 when restoring backup of 2005 DB to 2008

    only difference i see, beside the REPLACE command at the end, is the wizard script uses file extensions of .vndf and yours is .vmdf

    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 3, 2011 at 11:26 am

    #1333837

  • RE: Error: 18456, Severity: 14, State: 38. - Specified Database - Any way to find out WHICH Database?

    Guras (6/3/2011)

    I am not an expert, but sometimes I have used this to find out what database users are conencting to...

    In SQl server management studio

    running sp_who2 active ...

    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 3, 2011 at 11:16 am

    #1333831

  • RE: need help to convert nvarchar(255) 30-07-2007 to a datetime 2007-07-30 format

    the example converts string to datetime...then if you want a specific format, you've got to convert it back again:

    --Results

    /*

    2007-07-30

    */

    Select convert(varchar(10),convert(datetime, N'30-07-2007', 105) ,120)

    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 3, 2011 at 11:06 am

    #1333825

  • RE: Save ALL plans in 1 operation

    i would swear at one of the SQL Pass sessions, they mentioned that the SSMS 2005 GUI would not save multiple plans, and that they fixed in in 2008 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!

    June 3, 2011 at 10:58 am

    #1333818

  • RE: Generate data from a ramdom combination of temp tables

    yep...you've got to try to get away from cursor/loop line by line thinking.

    does this work like you expect?

    INSERT INTO #names([Name])

    ...

    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 3, 2011 at 10:24 am

    #1333793

  • RE: Execute Stored Procedure from Desktop and return errors

    can you put the code on a web page, wether an intra- or internet?

    that'd be simplest...single source, accessible from each desktop, web page could provide results and error...

    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 3, 2011 at 8:07 am

    #1333699

  • RE: client side em for sql server2008

    just the obvious:

    sql server management studio replacement

    what's wrong with the Microsoft tools again?

    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 3, 2011 at 6:47 am

    #1333634

  • RE: client side em for sql server2008

    obvious choice would be to simply install the SSMS Client tools.

    Another option would be an application like LinqPad, which has most of the things you'd look for in an app:...

    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 3, 2011 at 6:32 am

    #1333623

  • RE: client side em for ss2008

    duplicate post.

    Please don't crosspost. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1119355-146-1.aspx

    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 3, 2011 at 6:28 am

    #1333619

  • RE: client side em for sql server2008

    EM as in SQL 2000 Enterprise Manager?

    can you explain a little better what you want? are you looking for a GUI application to access SQL 2008? like SQL Server Management...

    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 3, 2011 at 6:25 am

    #1333615

Viewing 15 posts - 7,456 through 7,470 (of 13,460 total)