Forum Replies Created

Viewing 15 posts - 7,561 through 7,575 (of 13,460 total)

  • RE: Best method for moving constant flow of data into SQL

    Don't Panic: MERGE is just a fancy way to do what you've already done a zillion times:, but as separate steps...INSERT new rows, UPDATE matching rows, DELETE rows that were...

    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 6:07 am

    #1325714

  • RE: Best method for moving constant flow of data into SQL

    martynjreid (5/16/2011)

    Welsh Corgi (5/16/2011)

    What time constraints are you looking at?

    The ETL process takes anywhere from 30 mins to 8 hrs dependant on hardware and size of the source database.

    dumb question...

    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 16, 2011 at 4:41 pm

    #1325526

  • RE: Best method for moving constant flow of data into SQL

    for me the big question is the number of rows moved;

    when your procedure was running once a day, what did it do? MERGE statement? drop and recreate 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!

    May 16, 2011 at 3:06 pm

    #1325490

  • RE: View Only Role

    is an error returned, or just no data?

    check the schema of the underlying objects inside the view;

    for example, lets say dbo.View1 & 3 are accessing items under the same schema,...

    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 13, 2011 at 11:47 am

    #1324492

  • RE: Tab, CHR(9), not working in browser

    browsers ignore whitespace...tabs, CrLf and more than one space in a row; that's part of the html definition

    if you need to visualize whitespace, you'll need to html-ize the results...either 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 13, 2011 at 6:22 am

    #1324233

  • RE: Handling Email Opt out

    how about adding a column to your records to have an opt out date and optional reason in the database row for the emails; then when select FROM YourTable where...

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

    #1324059

  • RE: Help EXEC inside SP not working

    it's syntax: remove the word "SELECT" just before EXEC;

    looks like an artifact from trimming the code.

    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 12, 2011 at 11:42 am

    #1323871

  • RE: Database design and practices...

    5) All transactional tables will show who updated the record last and when

    if you only have a single userid being used to connect, how will this have any benefit? do...

    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 12, 2011 at 11:34 am

    #1323864

  • RE: Help EXEC inside SP not working

    euroray (5/12/2011)

    Please take a look at this:

    I don't get any errors but the email is not being sent. Looks like the EXEC sp_send_dbmail is being skipped. If I use 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!

    May 12, 2011 at 11:20 am

    #1323844

  • RE: Help EXEC inside SP not working

    does this return results/an explanation for unsent mail/failed mail?

    SELECT

    err.[description],

    fail.*

    FROM [msdb].[dbo].[sysmail_event_log] err

    inner join [msdb].[dbo].[sysmail_faileditems] fail

    ON err.mailitem_id = fail.mailitem_id

    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 12, 2011 at 11:07 am

    #1323835

  • RE: help needed with data access

    you cannot use 32 bit drivers on a 64 bit instance; the JET drivers are 32 bit, so you'll have to download the ACE drivers from microsoft instead;

    i had 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 12, 2011 at 11:05 am

    #1323834

  • RE: Trouble with Linked Server

    Janet first do SELECT * FROM sys.servers

    are you sure the servername is [LINKEDSERVERNAME]?

    next, after you see the server name, do this:

    EXEC sp_tables_ex MyLinkedServer

    that should give you the lsit of tables...

    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 12, 2011 at 11:00 am

    #1323832

  • RE: Cursor killing my server

    HowardW (5/12/2011)

    ...rewrite the update as a set based operation rather than a cursor. The performance of cursors for this type of work is unnecessary and dog slow.

    We can't tell 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!

    May 12, 2011 at 6:13 am

    #1323603

  • RE: Granting CREATE Procedure permission to user

    dilipd006 (5/12/2011)

    thnks for the reply

    obviously i created the login first and then created the user

    Still this error is coming

    you said when you are trying to use the user test....

    are...

    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 12, 2011 at 4:52 am

    #1323566

  • RE: Granting CREATE Procedure permission to user

    Login failed for user 'pradeep1'.

    the above error has to do with no login in the server for that user;

    that's a different issue, not related to the user/role you created...

    only...

    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 12, 2011 at 4:29 am

    #1323559

Viewing 15 posts - 7,561 through 7,575 (of 13,460 total)