Forum Replies Created

Viewing 15 posts - 5,956 through 5,970 (of 13,460 total)

  • RE: Add Date Specific MSRP to Orders Table

    notice how i provided all the code you might need to test the solution? if you can do the same, by providing either CTE or CREATE TABLE...INSERT INTO statements, you'll...

    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!

    February 8, 2012 at 10:05 am

    #1444645

  • RE: date and txn problem

    sj999 (2/8/2012)

    Hi

    I want to find all customer IDs that have txn type AB occurring within 24 hours of txn type CD for that customer for the years 2010 and 2011....

    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!

    February 8, 2012 at 5:35 am

    #1444440

  • RE: Table schema question

    shah.simmy (2/7/2012)

    if two tabel has two same schema,but not primary - foreign relation,i want to identify matching record from both table.how can i do it,i cant use join thre

    a foreign...

    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!

    February 7, 2012 at 7:34 pm

    #1444260

  • RE: Writing SQL scripts outside of SSMS

    linqpad is something i always carry in my portable apps flash drive;

    http://www.linqpad.net/

    it's got multiple query window/tabs, syntax highlighting as well as an object explorer and ability to run/test...

    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!

    February 7, 2012 at 6:51 pm

    #1444253

  • RE: Why remotely connecting to SQL 2005 express failed?

    you skipped over the reason i stated previously. slow down and read a little deeper.

    there are TWO instances of SQL on the server.

    the default instance, which is already using...

    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!

    February 7, 2012 at 2:49 pm

    #1444156

  • RE: how to retrive a password for sql auth account

    you cannot. simply reset the password to a new known value.

    Copy

    ALTER LOGIN Mary5 WITH PASSWORD = '<enterStrongPasswordHere>';

    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!

    February 7, 2012 at 2:19 pm

    #1444136

  • RE: Why remotely connecting to SQL 2005 express failed?

    the screenshot you posted showed port 1433, which is wrong. it cannot be 1433,

    choose another port.

    i personally like 14330., but that's me.

    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!

    February 7, 2012 at 2:17 pm

    #1444133

  • RE: Alternative to TRY Catch

    Laura as I remember it, it mostly depends on the error level that gets raised.

    anything 16 or above, like foreign key violations, constraint violations, etc cannot be handled in...

    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!

    February 7, 2012 at 1:45 pm

    #1444112

  • RE: Why remotely connecting to SQL 2005 express failed?

    halifaxdal (2/7/2012)

    You are right, I opened Configuration Manager, and checked protocol for TCP/IP there, it says it is configured as using dynamic port and the port option is empty, so...

    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!

    February 7, 2012 at 12:18 pm

    #1444041

  • RE: Why remotely connecting to SQL 2005 express failed?

    since this is a named instance and not the default instance, I'm sure it is using dynamic ports, which will NOT be 1433.

    to make it easier, i'd recommend changing...

    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!

    February 7, 2012 at 12:09 pm

    #1444037

  • RE: How to update the database table by removing trailing spaces from one of the columns?

    the existing data has trailing spaces; converting the column to varchar does not auto-trim the existing data.

    now if you run our original update statement, you should see the difference.

    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!

    February 7, 2012 at 11:18 am

    #1444001

  • RE: How to update the database table by removing trailing spaces from one of the columns?

    fawadafr (2/7/2012)

    @Fahey:

    Thanks for the feedback. I tried executing the following SQL statement but was unable to change the field type.

    ALTER TABLE [dbo].[document_control] MODIFY COLUMN [doc_path] [varchar](256) NULL

    Could you please 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!

    February 7, 2012 at 10:46 am

    #1443969

  • RE: How to update the database table by removing trailing spaces from one of the columns?

    well the matching RTRIM function will remove trailing spaces...so i think you want something like this:

    UPDATE [dbo].[document_control]

    SET [doc_path] = LTRIM(RTRIM([doc_path]))

    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!

    February 7, 2012 at 10:21 am

    #1443953

  • RE: MySQL Linked Server Problem

    2008 R2...is that 64 bit?

    if it is, you have to use 64 bit MYSQL drivers in order to create a linked server.

    that would be one more thing to double check....if...

    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!

    February 7, 2012 at 9:53 am

    #1443928

  • RE: Why remotely connecting to SQL 2005 express failed?

    it's gotta start with the basics, i think:

    since its an express instance, is the checkbox for allow remote connections checked? maybe via the Configuration?

    next, and probably the most...

    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!

    February 7, 2012 at 8:35 am

    #1443841

Viewing 15 posts - 5,956 through 5,970 (of 13,460 total)