Forum Replies Created

Viewing 15 posts - 10,111 through 10,125 (of 13,460 total)

  • RE: Modify column causes "tables will be saved" warning

    the why is easy...by design, when you use the GUI to change a table, it drops the table and recreates it. Not always, but since it is so easy 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 13, 2010 at 2:47 pm

    #1103341

  • RE: PARSE FULL NAME INTO LASTNAME,FIRSTNAME, MI

    that would occur if any space existed in the last name, before the slash.

    a name like Mac Bride/Bob Lee would make that happen... you'll need to tweak it based...

    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 13, 2010 at 12:37 pm

    #1103246

  • RE: PARSE FULL NAME INTO LASTNAME,FIRSTNAME, MI

    it takes a bit of manipulating, but you need to use substrings and charindex to find the slash, and grab the left and right parts of it; you have 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 13, 2010 at 11:14 am

    #1103211

  • RE: Export data from Sql Server 2005 to MS Access

    the Export Wizard gives you the option of copying tables or using a query in like the sixth step: much easier using the wizard than SSIS.

    you have to select your...

    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 13, 2010 at 9:10 am

    #1103129

  • RE: Foreign Key to a Foreign Key

    remember a foreign key can be created only on a column with a primary key or unique constriant; on it, an integer column that happens to have an FK doesn'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!

    January 13, 2010 at 8:10 am

    #1103078

  • RE: Execute multple stored procedures stored in a table

    i'm just guessing at your interface, but do you have some UI that has a link per SQL statement and they click one link to get the results, vs...

    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 13, 2010 at 6:55 am

    #1103010

  • RE: Execute multple stored procedures stored in a table

    I see; sort of like a self contained mini Query Analyzer/SSMS interface; I understand that, but why save the entry to be executed then?

    i had done something along those...

    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 13, 2010 at 6:47 am

    #1103002

  • RE: Execute multple stored procedures stored in a table

    well first let me throw out the standard security caveat: executing unverified, unsecure TSQL code that comes from an external source is a bad thing.

    I'd love to hear 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 13, 2010 at 5:20 am

    #1102973

  • RE: Batch updates with Trigger

    more details are needed i think; i think you are misusing the trigger functionality.

    it sounds like you are reprocessing every record in the 10 million row table if someone fires...

    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 12, 2010 at 5:45 pm

    #1102842

  • RE: Executing stored procedure within SELECT statement

    like GSquared said, it's possible, and substantially slower too.

    here is a simple example, which just runs sp_who; change your server name and this should work:

    SELECT *

    ...

    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 12, 2010 at 4:50 pm

    #1102827

  • RE: Using a CTE within a UDF

    yes you can use a CTE and recursive CTE's in a function;

    a lot of the Tally Table examples you'll find here do exactly that to build a Tally table dynamically,...

    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 12, 2010 at 12:53 pm

    #1102687

  • RE: BCP using xp_cmdshell

    ok...how about the hyphen in the server name? wrap it in brackets?

    -TECH-01 to -[TECH-01]

    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 12, 2010 at 12:45 pm

    #1102677

  • RE: BCP using xp_cmdshell

    it's probably permissions then...the service account does not have access to the C:\ drive.

    if you change it to just the file name , without the C:\, the file would get...

    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 12, 2010 at 12:35 pm

    #1102673

  • RE: Tools to Generate SQL Server 2005 Database???

    i think the basic version of SQLExpress does not come with a GUI, so you end up having to use a different program like LinqPad or something to use for...

    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 12, 2010 at 12:25 pm

    #1102667

  • RE: BCP using xp_cmdshell

    all my snippets I'm looking at do not have a space after any of the flags, for exampe -S TECH-01

    should be -STECH-01

    SET @sql = 'bcp "' + @sql +...

    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 12, 2010 at 11:37 am

    #1102632

Viewing 15 posts - 10,111 through 10,125 (of 13,460 total)