Viewing 15 posts - 2,686 through 2,700 (of 5,111 total)
Without the original data, how can we hope to get the results your after? Could you please post DDL and consumable sample data?
Thanks.
November 3, 2017 at 8:06 am
Oh no... definitely not being sarcastic. Quite the contrary. It's a bummer, though,...
November 3, 2017 at 8:05 am
November 3, 2017 at 7:16 am
You should know that you need to supply data with DDL and in a consumable format.
November 3, 2017 at 5:16 am
Joe Torre - Thursday, November 2, 2017 6:11 PMMainstream Support for SQL Server 2008 R2 ended in 2014.
Extended support still exists. Otherwise...
November 3, 2017 at 3:08 am
November 3, 2017 at 2:09 am
Notability of term. That is a strange way of wording it. Wonder who...
November 2, 2017 at 10:56 am
November 2, 2017 at 10:47 am
Your post doesn't make a lot of sense here. Firstly the query Select Sum(Amount) from table1; will return a result set with a single row and single (unnamed)...
November 2, 2017 at 10:26 am
Ahh, ok. If it's converting into a CSV then this will work (using STUFF and FOR XML PATH):
November 2, 2017 at 6:09 am
I almost think the OP is looking for a generic tool for every scernario, i.e. making their own LAG/LEAD function. That isn't going to happen.if you wanted to use a...
November 2, 2017 at 5:54 am
November 2, 2017 at 5:25 am
This isn't going to be a pretty join no. I don't see any reason to split into a Temporary table though, do the job in one go:
November 2, 2017 at 5:08 am
You could have a look at PowerBI, but, personally, I think SSRS would be a good choice here. if it's on a separate machine, you only need a web browser...
November 2, 2017 at 3:18 am
Depends how you want to display it, your requirements are quite vague. For example, you could use Excel. Run the script in SSMS, copy and paste the data out into...
November 2, 2017 at 3:03 am
Viewing 15 posts - 2,686 through 2,700 (of 5,111 total)