SameerKKhan (11/24/2011)

---

I have three Tables.One is

EmployeeMaster(EmpCode,EmpName,MobileNo)

Sample Date EmployeeMaster(1,SameerKhan,4512541321)

ClassMaster(ClassId,ClassName,EmpCode)

Sample Data ClassMaster(1,ClassA,1)

Here EmployeeCode in ClassMaster is the EmpCode from EmployeeMaster.

Attendance(StudentID,Class,Status)

sample data Attendance(445,ClassA,Absent)

Here Class will come from ClassMaster

Now suppose...

James123 (11/24/2011)

---

It doesn't matter which row is returned. If a case has two documents created on it in one day, I just need to know that a document was created...

James123 (11/24/2011)

---

Sorry, I should have said that I'm working in SQL 2000 so I can't use OVER()

You're right, I could check the ROW_NUMBER() but I only actually need to know...

James123 (11/24/2011)

---

Thanks for that. That's narrowed the returned dataset but we still have duplicates where rows with the same CREATIONDATE exist

CREATIONDATE | ...

James123 (11/24/2011)

---

Hello,

I have a document history table which records all of the documents created on all cases. I currently return the date of the most-recently created document and a case...

Hello and welcome to SSC!

The main reason that you are not getting any replies for your question, it that we don't have enough information from you to answer!

For starters, it...

Sorry, didn't see that part of your question.

@MyToMonth/100 <-- as both of these are INT, this essentially removes the...

eseosaoregie (11/24/2011)

---

I have recently found some sql script on the net that converts an integer of format yyyymm to a date time. I have used it and it works. HOwever...

Look up UNION.

--First, let's setup your sample data

DECLARE @TABLE AS TABLE (Date1 DATETIME, Date2 DATETIME)

INSERT INTO @TABLE

SELECT '2011-11-01 00:00:00.000', '2011-11-01 00:00:00.000'

UNION ALL SELECT '2011-11-01 00:00:00.000', '2011-11-02 00:00:00.000'

UNION ALL SELECT '2011-11-02...

Plenty of ways to do this.

DECLARE @table1 AS TABLE (nm CHAR(2), INT, address CHAR(3), abc CHAR(2), efg INT, xxx CHAR(1))

INSERT INTO @table1

SELECT 'aa', 1, 'bks', 'hj', 2, 'e'

UNION ALL...

Sorry,...

SQLSeTTeR (11/23/2011)

---

Is it possible to loop through all DB's with the following script?

DECLARE @user SYSNAME

DECLARE @sql NVARCHAR(300)

DECLARE cur_Users CURSOR FOR

SELECT name

FROM sysusers

WHERE islogin =...

stephen.staple (11/23/2011)

---

Thank you GSquared. I actually ended up with a very similar solution to yours.

First I defined a function:

create FUNCTION [dbo].[fn_GetTopMatch1](@LoginID AS int)

RETURNS TABLE

AS

RETURN

--

SELECT ...

Jeff Moden wrote an article about splitting delimited stings here[/url].

The main reason that you were not getting any replies for your question, it that we don't have...