Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Sergey
I have a book called Transact-SQL. I cannot find how to suppress null values in my results like the VFP function NVL(). I also cannot find anything about creating UDFs, but it does cover stored procedures. Would you please explain further?
Thanks!
>>Thanks for that.
>>
>>Can we use this in-line to make a derived table?
>>
>>select somefield from sometable inner join (DECLARE @StrConcat varchar(8000)
>>SET @StrConcat = ''
>>SELECT somefield,@StrConcat = @StrConcat + ', ' + title_id
>> FROM sometable
>> GROUP BY somefield) dt_concat on sometable.somefield = dt_concat.somefield
>
>No.
>
>>Or should I create a procedure and call it as a derived field?
>
>Sproc cannot be used as derived field. You can try UDF though.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only