Viewing 15 posts - 466 through 480 (of 8,760 total)
I have a little bit of good news, sort of. I have managed to find work at Parsons that has extended my stay to the end of September. Better...
August 14, 2020 at 4:18 pm
As far as I know Excel uses the same logic for converting typed, pasted and imported text. If you select a sheet can switch it all to text, everything...
August 14, 2020 at 3:22 pm
Further on the Excel CSV quirks, as all numbers are floating-point numbers in Excel, any manipulation of the cell value will result in the 15[n]+0[n]
😎
Create a CSV file
August 14, 2020 at 9:14 am
The import process is a different type of potatoes.
😎
OOXML and MOX, Open Office XML and Microsoft Open XML file standards are the same. I've tested around 17 different...
August 14, 2020 at 6:43 am
The import process is a different type of potatoes.
😎
OOXML and MOX, Open Office XML and Microsoft Open XML file standards are the same. I've tested around 17 different OOXML compliant...
August 13, 2020 at 12:10 pm
In nearly 30 years of using excel there are very few situations that don't have a straight forward work around.
built a report from an SQL database for a...
August 13, 2020 at 9:56 am
IIRC, there is also a difference in the dates in Excel and SQL Server. Only problem is that I don't quite remember what the problem, had...
August 13, 2020 at 9:49 am
So, getting my 8 and 10 year old grand kids to take showers during the Covid crisis has been tough. Today, after a lot of begging, the...
August 12, 2020 at 7:53 pm
Someone has to come clean, where is the Crystal Ball?
😎
August 12, 2020 at 7:49 pm
@Erikur, Sorry, I forgot to ask- is parallel execution worse, how to avoid parallel execution
As Frederico stated, it is neither better nor worse, it depends. For high cardinality sets...
August 12, 2020 at 7:46 pm
OMG! The world has gone completely mad. If you still don't think that spreadsheets rule the world, read the following article. The "punch line" after the title of the...
August 10, 2020 at 2:24 pm
Hi Eric,
Can you advise on this please,
say as in this case the date filter is only passed from the SSRS report, how can I redesign the whole thing. consider...
August 10, 2020 at 7:31 am
Hi Jeff,
It’s a SQL Sentry plan explorer file.
Thanks
NB
This is the reason for you not being able to attach the file, recommend that you post SQLPlan files in the future...
August 10, 2020 at 5:40 am
Hi Erikur,
The view is actually a datasource for an SSRS report and it has the date from and to filters. So the view is supposed to bring back all...
August 10, 2020 at 5:36 am
For me, the link provided by the OP doesn't point to an SQLPlan file. It points to a file but SQL Server doesn't recognize it as an SQLPlan.
Eirikur, what...
August 10, 2020 at 5:29 am
Viewing 15 posts - 466 through 480 (of 8,760 total)