Forum Replies Created

Viewing 15 posts - 7,546 through 7,560 (of 13,460 total)

  • RE: Replace repeated Char in a string by the Char itself

    here it is, i think: Jeff Modens "Replace Multiple Spaces With One" Article[/url]

    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!

    May 19, 2011 at 2:40 pm

    #1327364

  • RE: Replace repeated Char in a string by the Char itself

    ok what i posted works for my sample data, but not all situations...but i swear it's a variation of that concept.

    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!

    May 19, 2011 at 2:31 pm

    #1327354

  • RE: Replace repeated Char in a string by the Char itself

    there is an easy way, but it does require nested replaces; it will remove any number of repeating chars with a single one.

    I THINK this is how it works by...

    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!

    May 19, 2011 at 2:29 pm

    #1327352

  • RE: Select skip n

    you can use the row number function to do paging...is that what you are looking for?

    I don't want to use order by and then top

    is this a homework or...

    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!

    May 19, 2011 at 12:55 pm

    #1327309

  • RE: how to track the Database correction

    what if you are in the office those two days?

    do you have anything in place to track it when you ARE there?

    (Is you making changes to the database behind my...

    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!

    May 19, 2011 at 6:40 am

    #1327010

  • RE: trial

    SQL 2008 R2 Express[/url]

    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!

    May 19, 2011 at 6:35 am

    #1327004

  • RE: SQL 2008 R2 logins

    there are like three different versions of sp_help_rev_login...one for 2000, and two others for 2005/2008 i believe.

    you have to use the one specific to what you are exporting from.

    this 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!

    May 18, 2011 at 2:18 pm

    #1326774

  • RE: GROUPING by WEEK when weeks span multiple months

    Here's a Calendar Table Generator that I put together; it features all US National Holidays, as well some other that were fun to research and code; if the holiday 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!

    May 18, 2011 at 2:14 pm

    #1326773

  • RE: SQL 2008 R2 logins

    on the SQL2005 server, you'll want to download and use Microsofts sp_help_rev_login, which scripts out the logins on the other server.

    then run the results on the 2008 server.

    once the windows...

    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!

    May 18, 2011 at 12:03 pm

    #1326693

  • RE: A developer is using an db user (nonhuman) to make changes to production

    ugh;

    no dev area and developers making direct changers to production(since it;'s the only work area?); Paul's advice about liquor and updating the resume sounds even better now....

    how about a...

    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!

    May 18, 2011 at 7:46 am

    #1326452

  • RE: A developer is using an db user (nonhuman) to make changes to production

    DBAgal (5/18/2011)

    I inherited a database where the db users were granted db_ownership. After spending hours on the phone yesterday explaining the db change management process, the developer was given...

    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!

    May 18, 2011 at 7:21 am

    #1326431

  • RE: Table information

    a rename of an existing object doesn't count as a DDL operation, so it wouldn't be in the default trace; I investigated that on a similar thread previously.

    you'd want 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!

    May 18, 2011 at 7:06 am

    #1326412

  • RE: ARG! Char(185)

    here's one way to do it; I'm just creating a table full of high ascii chars, cross applying them, then using patindex to filter:

    with mySampleData

    As

    (SELECT top 255 row_number() OVER (ORDER...

    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!

    May 17, 2011 at 1:49 pm

    #1326110

  • RE: bcp row terminator

    PhilPacha (5/17/2011)

    Review the "BCP" entry in Books Online.

    -c controls the output of data - in this case, "character."

    -r controls the row delimiter

    -c -r /n

    Review the "BCP" entry in Books Online.

    Everything...

    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!

    May 17, 2011 at 12:52 pm

    #1326073

  • RE: export sql data

    homebrew01 's method is exactly how I've done it in the past.

    now for "special characters", what does that mean? high ascii?(so you have to export the results as NVarChar?), html...

    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!

    May 17, 2011 at 12:00 pm

    #1326026

Viewing 15 posts - 7,546 through 7,560 (of 13,460 total)