Viewing 15 posts - 2,686 through 2,700 (of 5,109 total)
Oh no... definitely not being sarcastic. Quite the contrary. It's a bummer, though,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 3, 2017 at 8:05 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 3, 2017 at 7:16 am
You should know that you need to supply data with DDL and in a consumable format.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 3, 2017 at 3:08 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 3, 2017 at 2:09 am
Notability of term. That is a strange way of wording it. Wonder who...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 2, 2017 at 10:56 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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)...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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):
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 2, 2017 at 5:54 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 2, 2017 at 3:03 am