As far as i know, we dont have any camel-casing utility function in T-SQL.

Here is my stab at it

DECLARE @Table TABLE

(

iD INT

...

Will Attribute_Value column contains mutilple words for every single row?

Or is it going to be only one word for all the rows in that column?

You can read this post to get to know about PARTITION BY and OVER clauses.

Sony Francis @EY (5/10/2012)

---

Dear Dhruvesh Shah ,

Try this

CREATE TABLE #Account

(

Ac_no int

,Code_list ...

Sony Francis @EY (5/10/2012)

---

I think the query which posted by ColdCoffee is not working

Suppose i want to insert Account Table with

insert into @Account( Ac_no, Code_list)

...

With 527 posts and 166 visits, you sure would have known how to post a question. Not good.

Please read this article on how to post your question --> How...

It is doable!

Please provide some sample data, table structure, business rules and expected result, like this format:

Sample data & table structure:

IF OBJECT_ID('tempdb..#t') IS NOT NULL

DROP TABLE #t

CREATE TABLE #T

(

...

Please provide some sample data, table structure, business rules and expected result, like this format:

Data:

IF OBJECT_ID('tempdb..#t') IS NOT NULL

DROP TABLE #t

CREATE TABLE #T

(

ColA INT

...

Try this:

IF OBJECT_ID('tempdb..#t') IS NOT NULL

DROP TABLE #t

CREATE TABLE #T

(

ColA INT

,ColB INT

,ColC INT

)

INSERT INTO #T

...

And expected resutls?

If there is sample data, Create table structure attached with your post - Then YES Of course!

One small correction here Eugene, you can SUM the columns used in GROUP BY, but...

Try this:

declare @CalendarStartDate datetime

declare @CalendarEndDate datetime

select @CalendarStartDate = '04/03/2006'

select @CalendarEndDate = '12/31/2018'

;WITH NumOfYears ( YrNum , DayCount ) AS

(

SELECT T.N , CASE WHEN T.N % 5 =...

I cant think of any way other than putting all those 50 columns in a WHERE clause.

Lets wait for the heavyweights to throw their thoughts on this

MERGE