Forum Replies Created

Viewing 15 posts - 9,046 through 9,060 (of 13,460 total)

  • RE: SP with two dataset to table

    ok i see what you mean now;

    i think the solution is to simply sp_helptext sp_helpuser, copy the parts of the code you DO want to use, and use THAT 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!

    July 14, 2010 at 4:09 pm

    #1193165

  • RE: Help with using mulitple replace in a function

    Joe Celko (7/14/2010)

    SQL is not a text language. Get a copy of Mellisa Data or other address data scrubbing tools. They will get you to CASS and 9-1-1 Standards much...

    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!

    July 14, 2010 at 12:56 pm

    #1193077

  • RE: SP with two dataset to table

    i can't duplicate the issue;

    i can certainly insert the EXEC SP_HELPUSER into a table, but what do you mean by a database alias?

    do you mean where you rename...

    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!

    July 14, 2010 at 12:44 pm

    #1193070

  • RE: Rows to Columns (The simplest way please)

    well...you're going to present someone with a grid with 700 + columns? why? I would simply NOT do that.

    maybe a redesign should be called upon to revisit why the data...

    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!

    July 14, 2010 at 11:10 am

    #1192989

  • RE: Help with using mulitple replace in a function

    Julie try this function agaisnt your data.

    this strips out everything that is not a number and not a character...so spaces, control characters, brackets or whatever get stripped out;

    that seems 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!

    July 14, 2010 at 10:37 am

    #1192973

  • RE: Limit Access to DB's

    failrly straightforward requirement Bosco. they will not get any rights you don't give them. if they connect with SSMS, you cannot hide the existence of other databases, but they can't...

    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!

    July 14, 2010 at 10:28 am

    #1192965

  • RE: Load data into multiple excel sheets in the same Excel workbook

    what you are asking for in your first post here is a number of complex things on some very wide subjects, much too wide to provide any meaningful examples without...

    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!

    July 14, 2010 at 7:30 am

    #1192800

  • RE: Select query

    dynamic data ?

    did you try either of the solutions we gave you?

    both work for an unlimited number of items...it's just string concatination.

    if that's not it, explain in detail what you...

    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!

    July 14, 2010 at 5:59 am

    #1192712

  • RE: Select query

    skcadavre (7/14/2010)

    Lowell (7/14/2010)

    turning the related rows into a comma delimited list is what you are after right?

    the easiest way is to use a neat trick using FOR XML.

    here's a nice...

    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!

    July 14, 2010 at 5:50 am

    #1192705

  • RE: Select query

    turning the related rows into a comma delimited list is what you are after right?

    the easiest way is to use a neat trick using FOR XML.

    here's a nice example 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!

    July 14, 2010 at 5:37 am

    #1192686

  • RE: Pivot operation help required

    here's a really nice example of using PIVOT that i picked up from a post here.

    if you were able to provide the two table definitions and some sample data, we...

    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!

    July 14, 2010 at 5:28 am

    #1192679

  • RE: Automating Restoring a Sql 2000 database to Sql 2008

    sticking with an actual RESTORE command is the best solution i think. you need to time things correctly, because you need to coordinate the following steps:

    1. a scheduled...

    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!

    July 14, 2010 at 5:20 am

    #1192677

  • RE: help with the xp_cmdshell

    it's a security thing....see this post for a long winded explanation with screenshots and a solution:

    http://www.sqlservercentral.com/Forums/Topic951702-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!

    July 13, 2010 at 12:31 pm

    #1192274

  • RE: help with the xp_cmdshell

    The command in SSMS should be running under my login ....

    That is the gotcha!

    xp_cmdshell will not use your login credentials. nope. not a chance.

    you expect it to use it, but...

    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!

    July 13, 2010 at 12:22 pm

    #1192269

  • RE: help with the xp_cmdshell

    xp_cmdShell doesn't use your personal credentials. it uses the account SQL starts with instead, and in your case that account doesn't have access to the network path:

    this is a common...

    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!

    July 13, 2010 at 11:58 am

    #1192257

Viewing 15 posts - 9,046 through 9,060 (of 13,460 total)