Timeline for Common TVF in SQL server to get results from differnt schema
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 15, 2020 at 9:05 | history | edited | CommunityBot |
Commonmark migration
|
|
| Dec 17, 2017 at 12:40 | comment | added | Mister Magoo | What does this mean ? "Since I have to pass dynamic paramters to , TableValue functions are the only options there" Perhaps describe more clearly why you have to use TVF? | |
| Dec 17, 2017 at 12:14 | vote | accept | napster | ||
| Dec 16, 2017 at 13:22 | answer | added | Dan Guzman | timeline score: 3 | |
| Dec 16, 2017 at 11:11 | comment | added | napster | @MichaelGreen, I have to query a database schema that takes daily snapshot of data for last 30 days. This is for reporting what were the sales and shipment as of yesterday, daybefore yesterday and today. The system doesn't have history lookup, and they do it this way. Since I have to pass dynamic paramters to , TableValue functions are the only options there and with the resutlts from TVF, further results will be massaged. So I was checking how to have schema agnostic TVF | |
| Dec 16, 2017 at 10:36 | history | edited | Michael Green | CC BY-SA 3.0 |
added 4 characters in body
|
| Dec 16, 2017 at 10:27 | comment | added | Michael Green | I have a feeling that you would get much better answers if you were to describe the base problem to be solved rather than a difficulty with a paticular solution you have developed. | |
| Dec 16, 2017 at 7:02 | review | First posts | |||
| Dec 16, 2017 at 10:28 | |||||
| Dec 16, 2017 at 7:02 | history | asked | napster | CC BY-SA 3.0 |