Forum Replies Created

Viewing 15 posts - 2,026 through 2,040 (of 13,460 total)

  • RE: Update Query

    data in a consumable format:

    i got tired of the solution just cleaning up the data, and gave up at that point.

    ;WITH MyCTE([ID],[Dept],[Address],[GroupID ])

    AS

    (

    SELECT '165683','32 ','P O BOX 602','2' UNION...

    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!

    February 9, 2015 at 7:27 am

    #1776371

  • RE: Customers stopped ordering a Product query

    my best guess base don the limited information.

    SELECT *

    FROM Customer

    --nothing in last 3 monts

    WHERE CustomerCode NOT IN(SELECT o.CustomerCode

    ...

    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!

    February 9, 2015 at 5:51 am

    #1776348

  • RE: The INSERT permission was denied on the object

    jahid786 (2/6/2015)

    I have the similar issue. I have checked all the suggestion you made on top of this discussion. But I could not find the reason of denying the insert...

    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!

    February 6, 2015 at 1:17 pm

    #1776159

  • RE: Call function/procedure from anywhere

    i do this ALL the time. i have suites of procedures using this ability.

    it requires a few things

    • it must be placed in the master database. (not some DBA_Utilities 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!

    February 6, 2015 at 11:44 am

    #1776135

  • RE: Passing Malformed email address to Send Mail Task

    i think the issue is connecting to an exchange server is not the same as connecting to an SMTP server, even if that server happen to be an exchange server.

    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!

    February 6, 2015 at 6:32 am

    #1776032

  • RE: Linked Servers Issues and Administration in BW Environment

    similar to what Igor posted, the code below can help find objects that reference a linked server, but can't find adhoc usage of a linked server, for example if an...

    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!

    February 5, 2015 at 5:51 am

    #1775662

  • RE: Looking for suggestions

    I'd go for local reachouts first. put together a letter of introduction/highlights of exactly what your skillset can contribute. this would not be a resume, but direct experience someone...

    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!

    February 5, 2015 at 5:34 am

    #1775652

  • RE: Deny Security Permissions for a SysAdmin

    nope, it is not possible to deny a sysadmin access to anything.

    permissions checks are shortcutted if you are sysadmin, and all deny/revoke permissions you might create are ignored.

    the only solution...

    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!

    February 4, 2015 at 2:36 pm

    #1775475

  • RE: Extract name from UNC Path

    wow, i fiddled with doing this with substring and charindex, and it is so ugly compared to using a delimitedsplit.

    /*--Results

    (No column name) UNC ...

    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!

    February 4, 2015 at 2:33 pm

    #1775474

  • RE: Trigger

    suppiunna (2/4/2015)

    The payment info from UI enters the Payment master table.. I created CDC on the master table.. So once the record is inserted in to Payments Master Table, 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!

    February 4, 2015 at 10:45 am

    #1775418

  • RE: Question related to indexes?

    to satisfy that specific query, i think an index on the four columns involved int he WHERE clause is needed, and INCLUDE all the columns in the SELECT, right?

    CREATE INDEX...

    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!

    February 4, 2015 at 10:27 am

    #1775402

  • RE: Trigger

    you probably want to fix the trigger., or remove the trigger completely and move the migration from one table to another to a job that runs every x minutes.

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

    February 4, 2015 at 10:13 am

    #1775392

  • RE: Deny Permission for an Object

    it is not possible to deny a sysadmin access to anything.

    permissions checks are shortcutted if you are sysadmin, and all deny/revoke permissions you might create are ignored.

    the only solution...

    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!

    February 4, 2015 at 9:02 am

    #1775363

  • RE: Load the latest csv files from file server using t sql automatically

    nikki123 (2/4/2015)

    Hi

    I need to load the latest csv files from file server , The files are placed in a folder called -

    Posted 02022015- --> csv files .

    I am...

    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!

    February 4, 2015 at 8:57 am

    #1775358

  • RE: Active Monitor equivalent script problem

    isn't this just the difference between a session(connection), and having actually committed a request?

    if i open ssms and open ten blank tabs, that's ten sessions, and zero requests.

    until i run...

    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!

    February 4, 2015 at 5:59 am

    #1775270

    • Viewing 15 posts - 2,026 through 2,040 (of 13,460 total)