Search results for query: *

You at that you are pulling in a string of integers, is the string comma delimited? If so then you can use Dynamic SQL. Something like this declare @sql varchar(2000) set @sql = 'UPDATE CT_Time SET Approved = -1 WHERE CONVERT(VARCHAR, THID) In (' + @TimeToApprove + ')' exec (@sql)

This doesn't sound like a back end problem so you might be better off asking your question on the following forum : http://www.macromedia.com/cfusion/webforums/forum/categories.cfm?catid=144 Good Luck!

I am guessing that the the poster is an Oracle User in which case you could try and use UPPER(), LOWER() or INITCAP() functions to achieve your result. Something like this might help : SELECT * FROM tbl WHERE UPPER(myfield) LIKE '%SMITH%'

The question states,

Relax rudy, it was a joke dude.

I don't think you should really store the images in a SQL Server table. How about storing a pointer to an image (you can use the file name, directory name or URL). The actual image can be stored on a file system or on the web server. It's actually quite easy to write ASP code to build an image...

no rudy, you just copied it from mine, now give up the little games! :p

Oops!! My mistake... the questio is clear if you read it properly D'oh. Anyway, hmckillop does the job.

Your question is a little bit vague to be honest. The second line of your id contains 3 different IDs separated by a pipe so do you want to return the first one or all three?! anyway, perhaps the following bit of code might give you the inspiration to find a better solution! declare @test...

Strictly speaking the above is not actually a nested select statement but a correlated sub query. A nested query would look something like : SELECT a.title, (SELECT codeName from Codes where CodeID = 1), a.price FROM books Of course there are many ways to achieve the same...

select title, retail from books, orders, orderitems where orders.customer# = 1017 and orders.order# = orderitems.order# and orderitems.isbn = books.isbn and retail = (select max(retail) from books b where books.isbn = b.isbn)

You can use the GROUP BY clause in your query. Something like this : SELECT townName FROM yourTable GROUP BY townName HAVING COUNT(*) > 1

select a.* from yourTable as a where a.datest = (select max(datest) from yourTable as b where a.claimno = b.claimno) and Status <> 'Case closed' Reality of a dreameR.

why not just CAST(0 as money) Reality of a dreameR.

Try this : DECLARE @TableName nvarchar(60) DECLARE @SqlCommand nvarchar(4000) CREATE TABLE #Return (TableName nvarchar(60), [RowCount] int) -- Get the names of all tables owned by 'dbo', excluding 'Shadow' tables DECLARE c_tbl CURSOR FAST_FORWARD FOR SELECT a.[name] FROM sysobjects as a...

select convert(datetime, '20040419', 112) -- using dat format YYYYMMDD

What do you mean it doesn't work for you?! Did you run this in query analyzer? Search Books On Line for more information on @@Version .. and it does give you information on the your current Service Pack (if you get it to work that is) Good Luck!

select @@version

Sunila, your query produces : 5 2003-04-23 00:00:00.000 20 5 20 5 2003-02-05 00:00:00.000 20 5 20 5 2003-01-02 00:00:00.000 21 5 20 6 2003-10-14 00:00:00.000 26 6 26 6 2003-09-21 00:00:00.000 26 6 26 6 2002-06-09 00:00:00.000 27 6 26

Nigel your script returns two rows only 5 2003-01-02 00:00:00.000 21 6 2002-06-09 00:00:00.000 27 How about : SELECT * FROM TBLAS A WHERE VENDORID IN (SELECT VENDORID FROM TBL GROUP BY PROPERTYID, VENDORID HAVING COUNT(*) > 1)