Forum Replies Created

Viewing 15 posts - 526 through 540 (of 1,473 total)

  • RE: Trigger , SET IDENTITY_INSERT ON and OFF Problem

    Deleted data with those 4 values are not going to Schema2.DIMCNAM

    but data regarding those 4 values is deleted in Schema1.DIMCNAM

    You still have not said what you want to do about...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 15, 2009 at 12:32 pm

    #1066434

  • RE: Trigger , SET IDENTITY_INSERT ON and OFF Problem

    But errors occurs since the value of identity column of the deleted row which is in Schema1.DIMCNAM

    already exists in Schema2.DIMCNAM

    Right, that's what I was talking about. And what do...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 14, 2009 at 1:06 pm

    #1065927

  • RE: Pls Help ....Script to List the Database Objects With Specific Keyword

    Use '%@A %' instead of '%@A%'. (There's a space after the A in the first one)

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 14, 2009 at 10:23 am

    #1065828

  • RE: Trigger , SET IDENTITY_INSERT ON and OFF Problem

    rahulsony111 (10/14/2009)

    Thanks for taking interest in my problem

    Those identity columns are already been set. I dont have an option to change them.

    All i have to do is to create a...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 14, 2009 at 10:03 am

    #1065811

  • RE: Pls Help ....Script to List the Database Objects With Specific Keyword

    Oops, just noticed PP posted the same thing :Wow:

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 14, 2009 at 9:53 am

    #1065802

  • RE: Pls Help ....Script to List the Database Objects With Specific Keyword

    So you're basically looking for column level dependencies. In 2000, I don't think you're going to find anything. Someone might have a script that'd get you closer than...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 14, 2009 at 9:52 am

    #1065799

  • RE: Pls Help ....Script to List the Database Objects With Specific Keyword

    And if you don't specifically need this to be a script, just hit F4 in your query analyzer to do an object search. If I didn't need my F4...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 14, 2009 at 8:03 am

    #1065687

  • RE: Stored Procs and Unused Parameters

    Michael Valentine Jones (10/13/2009)

    GSquared (10/13/2009)

    I'd say go ahead and include them. It means a little extra RAM being allocated, but it doesn't hurt anything beyond that.

    It allows the dev...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 14, 2009 at 8:00 am

    #1065686

  • RE: SELECTing values on different records based on rules

    Jonathan Melo (10/14/2009)

    The example values are for a single employee, in the end I'll have to handle multiple employees, but I figure if I can get something working with a...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 14, 2009 at 7:26 am

    #1065642

  • RE: SELECTing values on different records based on rules

    OK, I think I see part of it. The 8462.57 value is creating its own line because it is the 7th value (zeroes not counted apparently) in the row...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 13, 2009 at 8:57 pm

    #1065479

  • RE: SELECTing values on different records based on rules

    :blink: :blink: :blink: Uhh... Huh? :ermm: :ermm: :ermm:

    In either case, the solution is to add a new record and copy the rest of the...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 13, 2009 at 8:35 pm

    #1065478

  • RE: Trigger , SET IDENTITY_INSERT ON and OFF Problem

    OK, I knew this looked familiar. I see from your other thread that you are very new. Please explain as best you can, why you think you need...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 13, 2009 at 7:24 pm

    #1065468

  • RE: Trigger , SET IDENTITY_INSERT ON and OFF Problem

    Is there a reason you need that column to be an identity column at all? If you're using it as an identity column for other things, and just manually...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 13, 2009 at 7:19 pm

    #1065467

  • RE: Need to get one row per customer for multiple columns of data

    Or check out the Crosstabs / Pivots link in my signature.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 13, 2009 at 7:16 pm

    #1065464

  • RE: Trying to get this to work in one select statement

    If bob's solution doesn't work, can't you just join invoice to your CTE and use RowNumber in your case statements instead of the variables you're assigning now? No access...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    October 13, 2009 at 7:10 pm

    #1065461

Viewing 15 posts - 526 through 540 (of 1,473 total)