Sean Pearce (6/26/2013)

---

Do...

J Livingston SQL (6/25/2013)

---

Alan.B (6/25/2013)

---

Michael Valentine Jones (6/25/2013)

---

select top 1

a.[Date]

from

(

select top 1 b.[Date] from table1 b order by b.[Date] desc

union

select top 1 c.[Date] from table2 c order by c.[Date] desc

)...

I think...

Shadab Shah (6/25/2013)

---

J Livingston SQL (6/25/2013)

---

Shadab Shah (6/25/2013)

---

I search for Date functions for finding the max of the 2 dates. But such function does not exits.

Is there any easy way...

If you have db backed up as a single .BAK file then restoring the database is the only way I can think of; there is no way to dig around...

Are you looking for something like this...

--(1) THE DATA

IF OBJECT_ID('ajbtest.dbo.PivotA') IS NOT NULL

DROP TABLE PivotA;

CREATE TABLE dbo.PivotA (IDT int, A int, B int);

INSERT dbo.PivotA VALUES (24,1,-1),(24,2,-2),(24,3,-3),(24,4,-4),(25,5,-5),(25,6,-6),(25,7,-8),(26,8,-8),(26,9,-9),(26,10,-10);

--SELECT * FROM dbo.PivotA;

--(2) THE...

sabah_seattle (6/14/2013)

---

Hello sql1411,

Thanks for responding. Here is the error I am getting -

An error occurred during local report processing

An error has occurred during report processing.

Query execution failed for dataset "Sales".

Login...

I wanted to second that.

To get rid of those dashes you could do something like this:

DECLARE @x XML,

@x1 varchar(1000)='

- <CLUB>

-...

You would need to do something like this:

-- (1) SAMPLE DATA SETUP

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

DROP TABLE #tblHoliday;

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

DROP TABLE #dates;

--Holiday table, I only added New Years,...

Ed Wagner (6/12/2013)

---

There are plenty of articles out there on getting started doing it .NET. Here's one: http://msdn.microsoft.com/en-us/magazine/cc163473.aspx.

Depending on how you write it, this approach can be very efficient.

After...

mike.dinnis (6/12/2013)

---

Hello,

I have a table with five fields used to hold address data. Due to poor practices the users have been able to enter any data in any field. They...

I have a solution that will work with your sample data. I was trying to come up with something that works when there are more than 3 records but this...

vxhughes (6/6/2013)

---

Thanks to all for their recommendations.

I've already started on

http://beginner-sql-tutorial.com/sql-commands.htm

and

http://www.w3schools.com/sql/sql_intro.asp

and I've bookmarked "Stairway to T-SQL DML" at

http://www.sqlservercentral.com/stairway/75773

A couple of quick questions:

• Which of Itzik Ben-Gan's T-SQL fundamentals books do I...

OTF (6/6/2013)

---

bgraham 64271 (6/5/2013)

---

SQLSACT (6/5/2013)

---

Have a look...