Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dynamic SQL
No It should be like this I did not attach the SQL string because i don't know what exactly you are trying to do. This is just the call for the string with the respective parametyers declare @EBOID int sp_executesql @SQLstring,@params='@EBOID int',@EBOID=@EBOID OUTPUT- Adita
- Post #4
- Forum: Microsoft SQL Server: Programming
-
I just need help with syntax
AND CustTicket IS NOT NULL AND CustTicket <> ''- Adita
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Import CSV file with Duplicates, While using unique indexes?
You can use DTS but yo have to specify that you use unique index.- Adita
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Modifying a procedure to accept multiple conditions
set @x = 'select distinct((select cast(sum(Number_of_Responses)as float) from ' + @selectedview + ') / (select cast(count(distinct(imc_trackingnumber))as float) from ' + @selectedview + ')) as "# of Responses to Resolution" from '+ @selectedview+ 'where exists ( select *...- Adita
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Dynamic SQL
I know that it is not documented by Microsoft but you can declare in among the parameters used in the dynamic SQL Output parameters as well as input. You just have to declare a parameter which will store the value returned by the dynamic SQl @Myparam = @MyparamLocal OUTPUT You will be able to...- Adita
- Post #2
- Forum: Microsoft SQL Server: Programming
