Stored Procedures return values by means of parameters and not by return statement...The return statement in a procedure marks the end of execution and also the execution status of...

Will the values in @AnswerList always be available in PrescreenResponses table?

If no, then you have to change this SET @Answer = @Answer + ', ' + @TempAnswer

assignment statement...

Miranda Johnson (10/27/2007)

---

The input would look like this

SELECT udf_GetCheckboxAnswers (218, '2, 4, 5') AS AnswerString

The intended output in this example would be

Tuesday, Thursday, Friday

The second one I showed...

I think the problem is that you have not initialized any value for the variable @Answer which defaults to NULL .....

Here is the statement which will give the no. of hits by page type....

SELECT[LANGUAGE], COUNT( * ) AS [COUNT]

FROM(

SELECT( CASE

WHEN CHARINDEX( '.', REVERSE( [http_referrer] ) ) > 0

THEN...

You can build a select statement like....

select t1.snapshot_time, t2.snapshot_time, cast( varchar(10), t1.snapshot_time, 101) + '-' + cast( varchar(10), t2.snapshot_time, 101) as snapshot_period

from mytable t1 inner join mytable t2 on t1.tank_code...

Just add a WHERE clause such as 1 = 2 or TOP 0 in SELECT to return no rows...

Yes, you can upgrade your 2000 SE instance to 2005 EE, DE or SE...and also you can have multiple instances of sql server running a single box....

This statement will probably need a scan of the entire table or the clustered index....

I suggest...

You have to start your instance in single user mode by activating -m switch and then you can add logins/users through sqlcmd utility

Alergy (10/25/2007)

---

Peter and Ramesh - thank you so much for such prompt replies, the SQL gods are obviously smiling on me today! 😀 I'm fairly new to SQL...

EXISTS will only check for the existence of rows in the sub-query and it will not return any rows....and also it doen't matter if you specify a single column or...

Have you tried this one?

SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=G:\;Properties="Text;HDR=YES;FMT=Delimited"')...[jdm.001_aff.csv]

And fortunately it does support organizing servers into groups in means of registered server explorer🙂

- am I right in thinking that if #FindIDForMaxValue is actually a dynamicallygenerated SQL query, then simply putting it into the subquery as well would be extremely inefficient?

The query which...