Viewing 9 posts - 46 through 54 (of 54 total)
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...
September 6, 2012 at 7:58 am
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...
September 6, 2012 at 4:39 am
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...
September 6, 2012 at 2:39 am
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...
September 5, 2012 at 7:00 am
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...
September 4, 2012 at 8:34 am
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...
September 4, 2012 at 4:32 am
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...
September 4, 2012 at 3:09 am
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...
July 31, 2012 at 7:20 am
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 -...
July 31, 2012 at 6:57 am
Viewing 9 posts - 46 through 54 (of 54 total)