p.avinash689 (10/13/2013)

---

i have 10 records in sql table . the records contains data as gender with male and female. please reply me with a query that can change male into...

Without DDL and consumable sample data I won't venture a coded solution.

I do recommend that you look into the SQL 2012 LAG function: http://technet.microsoft.com/en-us/library/hh231256.aspx

I'd say start with this and decide what type_desc you need to check:

SELECT name, object_id, type_desc, create_date, modify_date

FROM sys.objects;

Not that it means much until you upgrade, but you may want to consider avoiding these 2 because they seem to fail in SQL 2012 using Cadavre's test harness:

SELECT DATEADD(dd,...

easy_goer (10/13/2013)

---

Hello. I have a portion of a table that looks like what I've listed below. This is just a small subset of the data that I'm attempting...

That looks like my query but I don't see any results attached.

BTW. There is the possibility that mine might not return what you expect if your base query returns...

james.ingamells (10/11/2013)

---

Hi Dwain,

I did have a go at your attempt, however if I want to be able to use this on a monthly basis i would have to do the...

Looks like homework, but if what you're after is the Names associated with columns A and B, perhaps a correlated sub-query would be best:

CREATE TABLE #Table1

(A CHAR(2), B CHAR(2),...

Firstly, in a query as follows there is no need for the second DISTINCT:

select distinct * from table1 where column1 in (select distinct column1 from table 1).

Secondly, you may be...

Sean - Love your cheat!

Another way:

SELECT DATEADD(minute, DATEDIFF(minute, '00:00', @TheTime), @DateTime)

Why don't you post the DDL you have created so far?

If you look at the fourth article in my signature links, therein lies a tool that I think is the Swiss army knife of all string handling functions. It...

Guess you didn't like...

Some might prefer in-line Tally tables.

DECLARE @start_date DATE = '1990-01-01';

DECLARE @rows INT = 6000;

WITH Tally (n) AS

(

SELECT 0 UNION ALL

SELECT TOP...

LinksUp (10/9/2013)

---

All 3 approaches worked! Awesome forum.

I really liked the Grouping because is was so straightforward. Why didn't I think of grouping! (Duh!)

Of course nothing beats a cte except a...