I am trying to get SQL Store procedure value to temp table.Please help me
I tired below solutions that not fit to my requirement. If anyone know other then this solutions please let me know
1. I tried OPENROWSET here we need to give user id and password, so i don't need that.
2. In Store procedure writing INTO statement this is also not fit for my requirement
3. Creating a table and writing exec statement with store procedure this is not a solution for my problem, because columns are dynamic in count.