Naidu PK

Forum Replies Created

Viewing 15 posts - 16 through 30 (of 75 total)

RE: Selecting a row per group based on multiple conditions

drew.allen - Thursday, February 22, 2018 12:33 PM
The standard way to do this is with a CTE/ROW_NUMBER() combination. You just have to...

February 22, 2018 at 12:49 pm

#1980838
RE: SSIS Package with a Derived Column

Thanks for sharing useful Info Thomas.
I had a case recently in my org where data is moved to SQL Server already but coming towards the derived column part,...

February 6, 2018 at 9:09 am

#1978722
RE: how to do Intermediate calculations for partial rows based on a particular field

Luis Cazares - Wednesday, January 31, 2018 1:27 PM
Naveen PK - Wednesday, January 31, 2018 1:14 PM

January 31, 2018 at 1:39 pm

#1978097
RE: Calculations using partial rows data and displaying the calculations in the middle of a report

pietlinden - Wednesday, January 31, 2018 11:02 AM
Unless you can group your data somehow, I don't think so. What you're describing is...

January 31, 2018 at 1:16 pm

#1978088
RE: how to do Intermediate calculations for partial rows based on a particular field

Luis Cazares - Wednesday, January 31, 2018 1:12 PM
Naveen PK - Wednesday, January 31, 2018 12:39 PM

January 31, 2018 at 1:14 pm

#1978087
RE: how to do Intermediate calculations for partial rows based on a particular field

Luis Cazares - Wednesday, January 31, 2018 12:10 PM
Naveen PK - Wednesday, January 31, 2018 11:24 AM

January 31, 2018 at 12:39 pm

#1978084
RE: Multiple Grouping with multiple tablix controls

LearnTSQL - Monday, January 8, 2018 6:35 AM
Dear Team,
I have a requirement to show the data at 3 different levels with multiple...

January 30, 2018 at 4:28 pm

#1977980
RE: how to get all values from one table repeated to each group on a column in another table

adish - Saturday, January 27, 2018 7:19 PM
Try this:
SELECT
        DF.LineNumber
        ,DF.MFN
        ,Years.TaxYear
        ,Tax.Value
    FROM
        @DisplayFields DF
        CROSS JOIN (SELECT TaxYear FROM @tax GROUP BY TaxYear) Years
        LEFT...

January 29, 2018 at 10:30 am

#1977726
RE: how to get all values from one table repeated to each group on a column in another table

Jeff Moden - Saturday, January 27, 2018 10:41 AM
Naveen PK - Friday, January 26, 2018 1:54 PM

January 27, 2018 at 12:42 pm

#1977630
RE: how to get all values from one table repeated to each group on a column in another table

drew.allen - Friday, January 26, 2018 2:20 PM
Here is one option. I initially tried an approach similar to Kevin's, but this seems...

January 26, 2018 at 5:01 pm

#1977615
RE: Refresh all views in a database

Good one. Simple and Easy.

October 28, 2016 at 3:49 pm

#1909443
RE: STUFF

timwell (9/3/2015)
David Harder (9/3/2015)
The question is valid. The BOL reference is valid. The comment about understanding how a function works is valid. But the reason the result of the query...

September 3, 2015 at 9:57 am

#1824365
RE: STUFF

kumar1pr (9/3/2015)
Naveen, a very good question. I played with this query and this is what I come up.
When you set @TrueValue = '' --- No space you get Null because...

September 3, 2015 at 9:55 am

#1824364
RE: Counting Rows

I was expecting some trick behind passing variable value from @b-2 to @a.
Easy one. Thanks Siva.

August 31, 2015 at 5:00 pm

#1823515
RE: Real to Float

Hugo Kornelis (8/13/2015)
EDIT: I just remembered that I blogged about this many years ago. For those interested: http://sqlblog.com/blogs/hugo_kornelis/archive/2007/10/17/so-called-exact-numerics-are-not-at-all-exact.aspx
Good one. Thanks for sharing.

August 13, 2015 at 10:38 am

#1819798

Viewing 15 posts - 16 through 30 (of 75 total)