ajf

i'm defining a parameter @para1

I want to be able to know that if @para1 brings back a null value, is there a case to then say...

"""

if @para1 is null then declare @para1=@para2

""""

Tried a few combos and cant seem to find the result i'm after...

does anybody know how this can be done? any help would be appreciated

Thanks

I currently cannot define the delimiters when I output the file to grid in sql server 08...

Do you know how this can be done?

any advice would be appreciated...

thanks in advance

when I am creeating a .csv output file after running my SQL script,

I need to have the first part of the information with a comma (,) delimiter and the second half of my data to have another delimiter (e.g. colon( )

any ideas how i would go about this?

thanks