Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 1,228 total)

  • RE: Query Help - difference between last and current year

    You can't solve this without a precise and complete definition of 'this year' and 'last year'. They mean different things to different people.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    February 11, 2010 at 2:35 pm

    #1117786

  • RE: Challenge of allocating collaterals to loans (many to many)

    It's more difficult without fixed boundaries but I don't think it's unsurmountable. Thanks for the extra info Elias.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    February 11, 2010 at 2:30 pm

    #1117783

  • RE: Challenge of allocating collaterals to loans (many to many)

    Hi Elias

    The code I sent you yesterday is primarily an attempt to identify facilities by means of a single surrogate key, and introduce a parent for common facility/collateral pairs, with...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    February 11, 2010 at 1:35 pm

    #1117751

  • RE: Challenge of allocating collaterals to loans (many to many)

    Hi Elias

    This job will be quite a bit easier if you could split table [dbo].[zzzCovers] into three, as follows:

    Collaterial information, which should have unique CollateralId.

    Facility information, which should have unique...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    February 9, 2010 at 2:29 pm

    #1116402

  • RE: Challenge of allocating collaterals to loans (many to many)

    Can you show what you are trying to do with the aid of a couple of sample tables and a result set?

    All the better if the sample data is...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    February 8, 2010 at 3:39 pm

    #1115837

  • RE: Stored Procedure

    Is this part of a data migration / ETL process?

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    February 7, 2010 at 8:39 am

    #1115189

  • RE: Comparing dates as conditions for inserting rows in table

    fmeuriot (2/6/2010)

    Hi,

    I'm new to SQL and have a problem with a query that I just cant seem to be able to solve.

    So, I have an Access database containing iclient number,...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    February 7, 2010 at 8:01 am

    #1115184

  • RE: number rows by group

    Use a column list for each of your three inserts into the temp table so that you know for sure that your query output columns are going into the correct...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    February 7, 2010 at 3:27 am

    #1115163

  • RE: delay expired problem in query

    Anybody wanna beer? It's friday! My shout. Get yer shoes on. Lynn I'll get you a coke.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    February 5, 2010 at 12:53 pm

    #1114727

  • RE: Recursive CTE: Is it possible to count records without an aggregate function?

    sgmunson (2/3/2010)

    Why? That's not the path this is going to take... The level is only going to be relative to the root level, not to any other value....

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    February 3, 2010 at 12:53 pm

    #1113139

  • RE: Recursive CTE: Is it possible to count records without an aggregate function?

    Hi Steve

    I've had a play with this one as well - obviously - and from what I remember you can get it out in 4 passes: 2, 2, 1, 1.

    The...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    February 2, 2010 at 3:15 pm

    #1112547

  • RE: Recursive CTE: Is it possible to count records without an aggregate function?

    sgmunson (2/2/2010)

    ...such a solution could solve a rather broad range of similar problems that are traditionally difficult to deal with in set-based code. My guess is that it...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    February 2, 2010 at 1:57 pm

    #1112523

  • RE: SQL SERVER 2008 Pivot

    Hi Jorge, can you post the CREATE TABLE statement for dbo.sipDimensionPos please?

    Cheers

    ChrisM@home

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 25, 2010 at 3:04 pm

    #1108417

  • RE: Query optimization

    Using all or most of the suggestions so far, and including gadget type depending on the source table:

    ALTER VIEW [dbo].[vw_AssetCommonDetail]

    AS

    SELECT DISTINCT d.[Gadget], d.AssetID, d.Location, d.Tower, d.[Floor], d.Cubicle, d.BaseVendor,...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 24, 2010 at 4:22 am

    #1107902

  • RE: Query multiple descriptions from single field of codes

    There's yet another way to do this if you want an output row for each code - with OR in the join to the lookup. This isn't often recommended because...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 24, 2010 at 4:08 am

    #1107898

Viewing 15 posts - 1,171 through 1,185 (of 1,228 total)