San snapshots can also cause an extra backup entry in your backuphistory. Are you doing SAN snapshots by chance?

:hehe::-D

Without table definitions and without sample data, all we could do is say the query you provided should do the trick.

rvenkatesan (4/3/2014)

---

i will make clear,

I am looking for items that have more than one occurrence in track, in the above sample track 204 has 3 distinct Multiples and the track...

If you are looking for 2008R2 and later, you can query a dmv for this info (throwing it out there due to the recent activity on this thread).

SELECT *

FROM sys.dm_server_services;

This should produce the results you have requested

DECLARE @table TABLE (Track INT, Books CHAR(1))

INSERT INTO @Table

VALUES (204,'A'),

(204,'B'),

(204,'B'),

(204,'C'),

(206,'A'),

(204,'A'),

(204,'A'),

(203,'A'),

(202,'C'),

(202,'C'),

(202,'B');

WITH presel AS (

SELECT Track

FROM @table

GROUP BY Track

HAVING COUNT(*) > 1

)

SELECT Track, Books

FROM @table...

Are you trying to dedupe the data in this table or just the result set?

rigolo

Jeff Moden (4/2/2014)

---

I guess that pretty much puts the cap on the rumor that the cloud was going to kill the position of "DBA" in all it's wonderous mryiad of...

That would be fun to have down in Vegas.

Interesting question

Oh and here is the rest of the setup to update ColumnB

DECLARE @table TABLE (ColumnA VARCHAR(20), ColumnB varchar(20))

INSERT INTO @table (ColumnA) VALUES ('2300>MC13');

SELECT SUBSTRING(ColumnA,CHARINDEX('>',ColumnA),LEN(ColumnA)-CHARINDEX('>',ColumnA)+1)

FROM @table;

UPDATE t

SET ColumnB = SUBSTRING(ColumnA,CHARINDEX('>',ColumnA),LEN(ColumnA)-CHARINDEX('>',ColumnA)+1)

FROM @table...

It is a limitation in Power.

SELECT POWER(2,34)

Produces

Here is a means to get that data that allows for some variances - just in case.

DECLARE @table TABLE (ColumnA VARCHAR(20), ColumnB varchar(20))

INSERT INTO @table (ColumnA) VALUES ('2300>MC13')

SELECT SUBSTRING(ColumnA,CHARINDEX('>',ColumnA),LEN(ColumnA)-CHARINDEX('>',ColumnA)+1)

FROM @table

ramyours2003 (4/2/2014)

---

one of the tlog file is configured as initial 1 TB , because of that we doint have space on the drive , is it possible to...