Forum Replies Created

Viewing 15 posts - 106 through 120 (of 13,460 total)

  • Reply To: Need help to insert Data into 2 Tables

    you can either  join the master_profile table  to the insert for the child table, or you can leverage the OUTPUT clause and capture the newly inserted data into a temp...

    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!

    December 5, 2019 at 1:37 pm

    #3704953

  • Reply To: Microsoft.Office.Interop.Excel Throws Exception

    so looking at the code, it is using Excel Interop to save to a tab delimited file;

    can you eliminate the middleman and just read the excel document with SSIS, and...

    • This reply was modified 6 years, 5 months ago by Lowell.

    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!

    December 3, 2019 at 8:25 pm

    #3703998

  • Reply To: Why do I need DAC if I am able to connect to the server via sqlcmd?

    that would only work on a very small environment right? I've got 64 prod servers and nearly 200 total including non-prod, and the number of times in the last year...

    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!

    December 2, 2019 at 3:36 pm

    #3703475

  • Reply To: Why do I need DAC if I am able to connect to the server via sqlcmd?

    DAC guarantees some memory is held in reserve for an admin to be able to connect,  whether you connect via sqlcmd or SSMS.

    so if the CPU on the server 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!

    December 2, 2019 at 1:44 pm

    #3703416

  • Reply To: Uninstall SQL Server products

    i think you have to uninstall all services and shared features by checking modify existing,and selecting everything that was previously installed via the SQL installer. i do not believe 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!

    December 2, 2019 at 1:40 pm

    #3703414

  • Reply To: The CTE Insert

    ram@digisource.co.in wrote:

    NICE , BUT RECEIVED ERROR AT MY END .

    there are three statements, so you have to evaluate which one is syntactically correct.

    two of the statements are not, so if...

    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!

    November 25, 2019 at 9:09 pm

    #3700765

  • Reply To: The data types varchar and datetime2 are incompatible in the add operator.

    datatime has an implicit conversion to varchar, based on your locale. datetime2 does not.

    the map below from microsoft has some other examples.

     

    • This reply was modified 6 years, 6 months ago by Lowell. Reason: wrong map!

    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!

    November 25, 2019 at 7:53 pm

    #3700729

  • Reply To: The data types varchar and datetime2 are incompatible in the add operator.

    you were originally planning to handle the null, so this is a bit better:

     

    SET @CaptureError= @CaptureError + ' ,Date: ' + coalesce(convert(varchar(10), @Date,101), 'NULL')

    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!

    November 25, 2019 at 7:31 pm

    #3700723

  • Reply To: look for the most efficient method

    i think the definitions of the index need to match the queries hitting the server. the multi column index is not equivalent to indexing three columns individually.

    a single index on...

    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!

    November 22, 2019 at 5:04 pm

    #3700074

  • Reply To: Failed to validate url

    sultikav i guess lets start with the basics:

    is the SSRS service up and running, so you can navigate to pages or the management links, and you are just having trouble...

    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!

    November 21, 2019 at 1:54 pm

    #3699611

  • Reply To: my backup maintenance plan is failing

    select * from sys.dm_server_services lists both the db account and the agent account. the db account(SQL) is what is used for backups.

    mapped drives are on a PER USER basis, and...

    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!

    November 20, 2019 at 9:40 pm

    #3699377

  • Reply To: Distance Zip Code Database

    you can poke around, but there is an open source zip code database here: you can easily find others.

    https://public.opendatasoft.com/explore/dataset/us-zip-code-latitude-and-longitude/table/

    https://gist.github.com/erichurst/7882666

    that has a latitude and longitude  for the center of each zip...

    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!

    November 20, 2019 at 9:22 pm

    #3699360

  • Reply To: Trying to deny delete inside a procedure

    i am pasting a full example below, with what is undoubtedly your issue with object ownership chaining.

    for SQL server, if you grant execute permissions to a procedure, underlying objects permissions...

    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!

    November 20, 2019 at 5:35 pm

    #3699283

  • Reply To: XP_send mail fail

    typically that error is invalid parameters, i think, and might be related to the @query paremeter

     

    since you didn't provide any details or sample code, lets start at the top:

    does sp_send_dbmail...

    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!

    November 19, 2019 at 12:30 pm

    #3698789

  • Reply To: Trigger store procedure with a file in SQL Server

    Create an SSIS package that processes the file;

    whether the procedure calls CLR to process the file, or you load the file contents into a SQL table via that SSIS package...

    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!

    November 18, 2019 at 10:18 pm

    #3698658

Viewing 15 posts - 106 through 120 (of 13,460 total)