The table looks like this:

LogicJobID

---------------------------------------------------------------------

CompID = 21

DeptID = 2 AND JobTitle = 'Clerk'2

CONTAINS(JobTitle, 'HR')3

JobTitle = 'Storesman' OR JobTitle = 'Warehouse Op'4

Then my source data might look like this:

EmpIDCompIDDeptID JobID

-----------------------------------------------

112Clerk

222Clerk

324HR Manager

436Storesman

546Warehouse...

dreamslogic (9/17/2009)

---

Hi Guys,

This is my first project can anyone help me by providing SQL query, how to generate below questions. They are three questions a,b and c.

Tblconsignment

Job_no, job_type, ...

Duplicate post: replied here,

http://www.sqlservercentral.com/Forums/Topic789422-338-1.aspx

Just to add to what ALZDBA said (which is what you should do first), I did find this document handy when I was doing the upgrade.(Its from MSDN) . I...

Duplicate...

http://www.sqlservercentral.com/Forums/Topic787911-338-1.aspx

Not sure if I understood your requirement properly but if its about the execution then I am sure you would have looked at the stored procedure being referred to in...

I have seen this in lot of databases. Some having just two columns for association and some with a primary key (identity values) . I would go either for the...

nitin.iec (9/14/2009)

---

as per Mr. White Ans i.e. OK. If the two things happened at EXACTLY the same moment (the database was set up so that the INSERT didn't block the...

amodi (9/14/2009)

---

Hello Friends,

I have two table(say table A and table B) variables, both contains records.

I want to delete records of table A that are not in table B.

How can i...

Thanks Bob 😛

ravi4work (9/14/2009)

---

I do not know why such a long query has been posted. it can be solved like this:

select * from vehicle_det A

where duehours= (select min(duehours) from vehicle_det where vehicle=...

Are you running DTS on SQL Server 2005? sorry its not an attempt to answer your question, was just curious to know. This is not the reason for your error....

Thanks for the post, it was clear.

A quick and dirty way to do that just to avoid cursor is this, I cant say this is the best, performance wise,...

Hi,

First of all your link has got some problem it seems. Its not opening the excel. Even if it opens, I dont think it will be of much help....

Not sure if this will serve the purpose!

Select Len('SQLSERVER') - LEN(REPLACE('SQLSERVER','S', ''))