Hari Sharma

  • Interests: Solving Analytical Puzzles, Making Friends, Movies

Technical Article

Function returns String in Proper Case [CamelCase]

This is a generalised Function that will return a String in Proper Case [Camel Case]. Means Afetr every space, first later will be in UPPER Case.Example:Input String: 'microSoft sql server'Output String: 'Microsoft Sql Server'

4.75 (8)

You rated this post out of 5. Change rating

2007-05-09 (first published: )

19,691 reads

Technical Article

Function to calculate Month End Date

This function will return you the month-end date. Input parameter may be any date of that month for which you want to calculate month-end.Example:Input: '2-20-2004'      Output: '2-29-2004'Input: '2-15-2004'      Output: '2-29-2004'Input: '3-20-2004'      Output: '3-31-2004'Input: '3-30-2004'      Output: '3-31-2004'

3.2 (5)

You rated this post out of 5. Change rating

2007-05-08 (first published: )

1,315 reads

Blogs

The pros and cons of self-service BI: What every industry leader should know

By

The post The pros and cons of self-service BI: What every industry leader should...

Off to the PASS Data Community Summit 2024

By

As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...

Implement a RAG Solution Using Azure SQL Database

By

AI and ChatGPT are all the rage these days.  Seems like around every corner...

Read the latest Blogs

Forums

Error sub query return more than one value

By reza.asali

insert into NewKms8081..members SELECT (select u2.Id from SecurityKms8081..users u2 join SecurityKms8081..Import_users_barghGharb i2 on i2.code_personeli=u2.PersonnelNumber...

How to change font size in Query window

By MurraySobol

I am running SQL Server 20.2. When I copy a query into the query...

is the ssrs auto refresh without its faults

By stan

Hi, i considered power bi with embedded for this.    Not a big fan...

Visit the forum

Question of the Day

Cloud Sources for the Data Migration Assistant

Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)

See possible answers