I think a self join is required:


select distinct
d1.id
from dtlstbl as d1
inner join dtlstbl as d2
on d1.id = d2.id
and d2.refid = 2
where

A quick and dirty method would be to select into a temp table that has a identity column and then use that as the basis for your query. I wouldn't use this method if performance is high on your...

Books Online (http://msdn2.microsoft.com/en-us/library/aa257103.aspx) is probably a decent way to start.

Also I suggest trying some queries with the Northwind database; work out how to add...

sqlite (http://www.sqlite.org/) is exactly what you're after.

"...SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite...

I hope you didn't quit your day job.

Create a job, insert what you get from your query into another table.

Don't store images in your database; you're best storing them on your file system and storing their location/filename in the database



name | age | image...

try grant select on sales to sqluser

If you look up the grant function on msdn you can finely tune the privileges for each table/database/user/whatever.

Limitation of SQL server I presume (I use PostgreSQL).

Here is an ugly way to do it


select *
from t1
where task not in (select task1 from t2)
and task not in (select task2 from t2)

Ok,

For this I've called the tables t1 and t2.


select *
from t1
where task not in (
select task1
from t2

Hi,

Could you give us the names of the columns? I'm not sure I understand exactly what you're doing.

duplicate of what? all duplicates? why don't you have a unique identifier? do you have any validation? why are you here? why am i answering you?

I don't think there is anything wrong with updating two tables using two statements.

If you wrap them in a transaction you will ensure that you don't only update one (ie if one fails neither are...

ALTER PROCEDURE UpdateAccounts
@contactID int,
@accountID int
AS
begin transaction
UPDATE [Contact Account ]
SET [Account ID] = @accountID
WHERE [Contact ID] = @contactID

UPDATE...

AFAIK MSSQL does not support partial indexes (like PostgreSQL, Teradata, Oracle etc).

You may be able to get the functionality you require using a indexed view.

Storing movies in the actual database will impact its performance hugely.

I think the approach you should be taking is storing the location of the file in the db and storing the file on the file...

SELECT RNO,PNAME,AGE,'discharged' as STATUS
FROM TAB1
WHERE enroll_status = 'D'
union
SELECT RNO,PNAME,AGE,'queued' as STATUS
FROM TAB1
WHERE enroll_status = 'Q'
union
SELECT...

may be typos here but you should try not to use square brackets in your sql; makes it much harder to read

also it is easier to join tables in the from clause rather than where, it makes more...

I don't know much about access (except to avoid it).

It was SQL I'd suggest you look at the convert() function in tsql.

I don't really get what you mean with your data conversion either but you...

select top 1 with ties your_column
from your_table
group by your_column
order by count(*) desc

your auto-incrementing id field

SELECT product,max(transaction_date)
FROM tbl
GROUP BY product (http://msdn2.microsoft.com/en-us/library/ms177673.aspx)

select id from mytable mt where (mt.id % 5) = 0

select @newrowcount = 'NUM'
from ExcelToSql
where NUM = @rowcounter



this bit is wrong. it should be :


selec @newrowcount = NUM

missed the from and where clause off the select



use barcodedb

declare @rowcounter integer,
@rowcount integer,
@newrowcounter integer,
@newrowcount integer

ok, i'm assuming you have an id column as your pk

i probably have loads of errors in here but don't have mssql to try it with, hopefully what im doing is apparent though.




declare...

this (http://support.microsoft.com/kb/q164485/) article on Microsoft's support site may help

or a trigger

i dont use SQL Server much these days, but is there not a isNumber() or isNumeric() function?

If there isn't im sure writing your own wouldnt be that difficult. Just attempt to cast a varchar as...

i think the best way to tackle this is to make a stored proc that does the check and put the details of the birthday people in a temp table, once you've got them all use xp_sendmail...

that would work if

a) the values were in another table

b) and they werent in a comma delimited list as per the original question :)

no problem, but with your solution i don't understand why you use an if..else statement here



im sure you'd get the same result by just saying

select NoOfVacancies, JobRole
from JobVacancy...

I don't think you need to implement raid to solve this issue (it would do, albeit expensively), adding a new hard disk and creating new filegroups on it would be sufficient. Creating file groups and...

select
NoOfVacancies,
JobRole
from JobVacancy
where (JobRole like @JobRole + '%')
or (JobRole is null)

i'd imagine making a stored procedure to deal with the inserts would be the easiest way.

you can modify this sp to scroll through the list and put the whole lot of your list into variables then...