qamar 52306 (1/1/2013)

---

Hello

I want to select records such that if a user logs in again within 10 minutes it should ignore it, and only return the rows if the...

[font="Arial Black"]Happy New Year from the Tent in the Desert![/font]

Was noted, just responding to the alternate way the most recent responder posted. Plus, that is the beauty of this site, it...

From which table do you want to delete the records?

Another way:

declare @CurrentDate datetime;

declare @emp table

(empid int identity(1,1) primary key clustered, dob datetime not null);

insert into @emp (dob)

SELECT convert(datetime,'1962-12-11 00:00:00.000') AS dob UNION ALL

SELECT convert(datetime,'1958-03-28 00:00:00.000') AS dob UNION ALL

SELECT...

opc.three (12/31/2012)

---

Sounds like homework, which is fine, I am happy to help, but please post the some table definitions (CREATE TABLE statements) and some sample data (INSERT statements) as well...

The following is your code formatted, using 2-part naming in the SELECT list by using table aliases in the FROM clause, and moving the HAVING criteria to the WHERE clause.

SELECT

...

cs_source (12/31/2012)

---

Thank you for the information. I would like to delete this topic as i have found my answer. After reading a bit it seems that we can't delete our...

The same, check here: http://msdn.microsoft.com/en-us/library/ms188283(v=sql.100).aspx.

You were asking the wrong question and it would have helped if you posted the DDL for the tables, the sample data, and expected results to begin with. Look at...

CREATE TABLE dbo.vComputer(

Guid VARCHAR(128),

Name VARCHAR(128)

);

GO

INSERT INTO dbo.vcomputer(Guid, name)

VALUES ('333','PC1'),

('222','pc2'),

('111','PC3');

GO

CREATE TABLE dbo.InvInstalledFileDetails(

FileDetailsID INT IDENTITY(1,1),

ResourceGuid varchar(128),

...

This seems to work on a single table query:

CREATE TABLE dbo.InvInstalledFileDetails(

FileDetailsID INT IDENTITY(1,1),

FPath VARCHAR(128),

PrgName VARCHAR(128)

);

GO

INSERT INTO dbo.InvInstalledFileDetails(FPath, PrgName)

VALUES...

lawson2305 (12/31/2012)

---

This is returning every system in the dB including the ones which my query locates.

I think this needs to basically bring up all systems distinct and remove what is...

lawson2305 (12/31/2012)

---

Ok here is a sql I run that tells me all my machines that have java installed.

SELECT DISTINCT i.guid, i.name

FROM dbo.Inv_Installed_File_Details fd

JOIN vComputer i ON i.Guid =...

You may want to read this article, Managing Transaction Logs[/url].