Forum Replies Created

Viewing 9 posts - 46 through 54 (of 54 total)

  • RE: One to many relation

    I'd guess you'd want something like a PIVOT.

    Something like

    SELECT T1.recordid,

    T1.description,

    MAX(Case WHEN T2.Status = 'New' THEN T2.time END) AS NEwStatus,

    MAX(Case WHEN T2.Status = 'PEND' THEN T2.time END) AS PendStatus

    FROM Table1 AS...

  • RE: CASE STATEMENTS

    If the where clause in both is the same, you can simply select both @Sums in the same statment, put all the common parts in the WITH CTE, and put...

  • RE: Learning SQL from Scratch

    Hi Clive,

    Just to muddy the waters, there is also ADO.NET Entity Data Modelling, which comes built into Visual Studio 2010. Its similar to LINQ - in that you select...

  • RE: Learning SQL from Scratch

    VB - I assume you mean VB.NET? - Do you have Visual Studio (at least Version 2008 if you want to use LINQ) - if Not you can get...

  • RE: Adding process to SQL query

    OK this is not ideal, as its proving to be quite tricky, however its *nearly* there

    There are 2 problems

    1) it only goes up to column 48 - that is because...

  • RE: Adding process to SQL query

    Hi

    Thanks for the updates. I've managed to get your code working.

    My result is gets the same column output as yours, but no data

    I Just added your datavalue to the...

  • RE: Adding process to SQL query

    Hi your post has not been ignored, its just very complex for a 'newbie' question. I can't actually answer your question yet, though I have had a look.

    You have...

  • RE: Detect hex 0x00 in nvarchar column

    Just getting to grips with SSIS.

    Redirecting error rows helped

    I have now found a new error: "Could not retrieve data for column Content. Error is The value is too large...

  • RE: Detect hex 0x00 in nvarchar column

    Thank-you

    Your code has helped me establish that a rogue hex 0x00 is not the cause of the original error. I'll raise it with the 3rd party supplier -...

Viewing 9 posts - 46 through 54 (of 54 total)