Forum Replies Created

Viewing 15 posts - 10,066 through 10,080 (of 13,460 total)

  • RE: Alternate of Row_Number() in SQL 2000

    to do the equivilent of row-number() in 2000, I've always had to create a temp table with an extra column, insert the data into the table, then run an additional...

    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!

    January 27, 2010 at 7:14 am

    #1109269

  • RE: How to write/ combine two expressions in Derived column

    jyoti_bhatt (1/27/2010)

    How can I amend this expression to replace it to NULL rather than "" (a space)?

    REPLACE([Column_name],"-","")

    All help will be appreciated?

    Many Thanks.

    jyoti you would not replace part of a string...

    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!

    January 27, 2010 at 6:39 am

    #1109242

  • RE: SQL tables

    here's another script that i use a lot;

    i stick it in master, and then in any database i might type "sp_find order" in any database;

    and it returns all tables(or views)...

    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!

    January 26, 2010 at 10:45 am

    #1108818

  • RE: Stored Proc - Dealing with Orders and OrderDetails...

    steve whenever i have an overall status that depends on the details, i do not store it in the parent/Orders table. I always try to calculate it based on 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!

    January 26, 2010 at 10:39 am

    #1108817

  • RE: How to write/ combine two expressions in Derived column

    jyoti_bhatt (1/26/2010)

    Many Thanks for your response much appreciated.

    These are my two expressions, how would I combine then?

    REPLACE([Column_name],"-","")

    (ISNULL([Column_name]) ? "" : [Column_name])

    gotcha; you want to replace any value with isnull...

    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!

    January 26, 2010 at 8:58 am

    #1108742

  • RE: How to write/ combine two expressions in Derived column

    duplicate post.

    no need to cross post to multiple forums it fractures the answers you get ,and makes posters duplicate others work.

    the "Recent Posts" link shows us everything.

    continue the thread here:

    ...

    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!

    January 26, 2010 at 8:50 am

    #1108735

  • RE: How to write/ combine two expressions in Derived column

    you probably want to show us the two expressions, and how you want them to be used together , i would think.

    a crappy example is the ISNULL function is an...

    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!

    January 26, 2010 at 8:46 am

    #1108733

  • RE: Syntax Help PLEASE

    g_dion (1/25/2010)

    ... Create Table stuff. The database and tables were already there,....

    glad i could help a bit g_dion; i'm glad you were able to do what you needed to.

    what i...

    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!

    January 25, 2010 at 2:47 pm

    #1108409

  • RE: vb.net regular expressions between two words

    discovered that my problem was the period in the pattern...the period matches an character except a new line...the patter i'm using, if anyone else ever needs a regular expression 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!

    January 23, 2010 at 12:43 pm

    #1107800

  • RE: Restore database failure

    weird, I've always been told that a backup from a previous version(2000,2005) can be restored on 2008.

    my google-fu found this link at MS, which says you can get that 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!

    January 22, 2010 at 10:05 pm

    #1107685

  • RE: Syntax Help PLEASE

    you'd get much better,understandable answers if you were able to provide the CREATE TABLE definitions of your two tables; psuedo code like table_new and table_old is not nearly as useful...

    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!

    January 21, 2010 at 4:13 pm

    #1107002

  • RE: Integer bigger than bigint?

    i have to go with lobbymunchers suggestion; a standard parent child relationship would be much more appropriate; i think you are mentally locked into bitwise operations because it's neat 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!

    January 21, 2010 at 4:04 pm

    #1106999

  • RE: Deleting a User from more than one Database

    the command is extremely basic, all available in books on line;

    use database1

    drop user webdev

    use database2

    drop user webdev

    what are you having trouble 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!

    January 21, 2010 at 3:04 pm

    #1106978

  • RE: Selecting out specific data

    you definitely need some coffee; god knows i've drawn blanks like that before my daily caffiene infusion.

    if you need the max(payment date) per company, you simply need a group by;

    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!

    January 21, 2010 at 7:51 am

    #1106707

  • RE: users stored in database

    Thanks Gail!

    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!

    January 21, 2010 at 7:06 am

    #1106675

Viewing 15 posts - 10,066 through 10,080 (of 13,460 total)