Forum Replies Created

Viewing 15 posts - 10,981 through 10,995 (of 15,376 total)

  • RE: Generate a checkletter (code)

    Not really sure what your question is but you can read about substring here. http://msdn.microsoft.com/en-us/library/ms187748.aspx

    What are the business rules for this? This looks pretty strange.

    August 21, 2012 at 7:49 am

    #1528131

  • RE: SQL Procedure Performance in different networks

    rahul_yerramareddy (8/20/2012)

    Hi,

    In my project there are two servers local and central. My central server is in Network1 and local server are in any network(like Network1,Network2 etc). I wrote a procedure...

    August 21, 2012 at 7:39 am

    #1528120

  • RE: Calling a Procedure from a Trigger

    KEVHOUSTON740 (8/20/2012)

    Yes, just as you wrote it.

    <HappyDANCE>

    Dance_Jig()

    </HappyDANCE>

    LOL 😀 Glad that worked for you.

    August 21, 2012 at 7:05 am

    #1528097

  • RE: Calling a Procedure from a Trigger

    KEVHOUSTON740 (8/20/2012)

    Sorry if I confused you. The looping was working as it was entering in the passed values from the trigger, but not entering the child data into the...

    August 20, 2012 at 3:07 pm

    #1527874

  • RE: Calling a Procedure from a Trigger

    KEVHOUSTON740 (8/20/2012)

    The data does exist. I am looping through the data because there may be 1 or 20 child data sets, per parent, and i need to have the...

    August 20, 2012 at 2:45 pm

    #1527866

  • RE: Calling a Procedure from a Trigger

    This seems to be the same thing as your loop.

    ALTER PROCEDURE [dbo].[uspNHistory]

    -- Add the parameters for the stored procedure here

    @NH_ID INT

    ,@N_ID INT

    AS

    DECLARE @CNID INT

    ,@CID INT

    ,@CA NVARCHAR(50)

    BEGIN

    -- SET NOCOUNT ON added...

    August 20, 2012 at 2:33 pm

    #1527862

  • RE: Calling a Procedure from a Trigger

    KEVHOUSTON740 (8/20/2012)

    I have 3 tables (1 parent and a child table) that are updated using one form. The child table is a "many to one" relationship with the parent....

    August 20, 2012 at 2:27 pm

    #1527859

  • RE: unbalanced [] in sqlserver identifier

    Sean Lange (8/20/2012)

    ben cohen (8/20/2012)

    Is this a SQL Server 2008 bug? It parses fine. Note that the [] are unbalanced.

    CREATE TABLE [dbo].[abc](

    [a] [int] NULL,

    [transaction[0]].status] [nchar](10) NULL

    )

    What do you mean they...

    August 20, 2012 at 2:14 pm

    #1527856

  • RE: unbalanced [] in sqlserver identifier

    ben cohen (8/20/2012)

    Is this a SQL Server 2008 bug? It parses fine. Note that the [] are unbalanced.

    CREATE TABLE [dbo].[abc](

    [a] [int] NULL,

    [transaction[0]].status] [nchar](10) NULL

    )

    What do you mean they are unbalanced?...

    August 20, 2012 at 2:13 pm

    #1527855

  • RE: varbinary(max)

    Rainmaker097 (8/20/2012)

    Output to file or text doesn't work. But I will dig some more. Thanks a lot for explaining this to me. Much appreciated.

    What do you mean it doesn't work?...

    August 20, 2012 at 2:09 pm

    #1527853

  • RE: varbinary(max)

    SQLKnowItAll (8/20/2012)

    Rainmaker097 (8/20/2012)

    I see what you mean thanks. These are config info for several applications and you are right, they don't have to displayed.

    But is there any way I can...

    August 20, 2012 at 2:00 pm

    #1527849

  • RE: varbinary(max)

    Rainmaker097 (8/20/2012)

    Hi,

    if it is only going to display 8000 chars, what is the point of using a column that can have more than 8000 chars?

    Am I "select"ing it wrong?

    RM

    The data...

    August 20, 2012 at 1:43 pm

    #1527837

  • RE: Create Trigger within StoredProc

    Luis Cazares (8/17/2012)

    No one said they were working on a production database.

    I believe that most problems like this should be solved with other administration options and not triggers. I wouldn't...

    August 17, 2012 at 2:16 pm

    #1527249

  • RE: Create Trigger within StoredProc

    Luis Cazares (8/17/2012)

    Sean Lange (8/17/2012)

    Why do you have users that are not competent with sql that have SSMS installed on their desktops? If they can't be trusted with SSMS get...

    August 17, 2012 at 1:14 pm

    #1527231

  • RE: Create Trigger within StoredProc

    DBA_SQL (8/17/2012)

    Well I have a Scenario: We have users who requires db_datareader and db_datawriter permissions to run there front end applications. We are using windows authentication as access permissions....

    August 17, 2012 at 12:46 pm

    #1527222

Viewing 15 posts - 10,981 through 10,995 (of 15,376 total)