Viewing 15 posts - 1 through 15 (of 133 total)
Thank you Andreas I will certainly check this out, the thread also links to
Which looks promising..
February 11, 2021 at 4:28 pm
Never used SQL anywhere and I haven't used Crystal Reports for many years. This is from memory so might be wrong. Assuming your tables are identical in MSSQL Server and...
February 3, 2021 at 12:45 pm
Copying SQL into Excel's connection properties window and clicking refresh.
The data is saved in the workbook. If the user has SQL rights an optional refresh will work otherwise fail but...
January 20, 2021 at 8:01 pm
For a bunch of string fields, numbers you're absolutely right.
I use the last excel file, which I just go into and change the query save it and send it. The...
January 20, 2021 at 7:07 pm
I know I'm not answering your question here.
I'd be mindfull about copying and pasting data from SQL to Excel because of locales; how does Excel know what format your date...
January 20, 2021 at 2:33 pm
Thanks Scott
I will not use this time, but I'm going to file this away - I can see this being useful sometime.
December 3, 2020 at 6:30 pm
Thanks Scot
I've scripted ALTER statements on the indexed views so I get to keep permissions. I've also included index creation as running the ALTER drops the indices.
I've not used synonym...
December 2, 2020 at 10:11 am
Thanks, not only do I struggle with UNPIVOT.
I also cannot figure out apply. I get it when passing parameters in e.g. apply yo every value.
Is this the same as
November 18, 2020 at 6:57 pm
Thanks Jeff and Sergiy for all your help.
I have a much better understanding now and have some design ideas: instead of triggers, partitioned views I can use not just in...
September 9, 2020 at 5:56 pm
I don't see much advantage to changing ProcessName or Type to a key from a "process table" or "type" table. In the face of the other tables, it's a...
September 9, 2020 at 9:44 am
Sergiy and Jeff both good points
CREATE TABLE [dbo].[LogFiles](
[ProcessName] [nvarchar](64) NOT NULL,
[type] [nvarchar](64) NOT NULL,
[From] [nvarchar](260) NOT NULL,
[To] [nvarchar](260) NOT NULL,
[Error] [int] NOT NULL,
[Message] [nvarchar](520) NOT NULL,
[DateAdded] [datetime]...
September 8, 2020 at 4:23 pm
But.. If some reports don't filter on Date they wouldn't benefit from the new index design.
The only query that actually does a select on this is the purge routine...
September 7, 2020 at 9:17 pm
Hi Sergiy
Thanks for your reply. I do appreciate it as I learn.
Happy because:
On an ANOTHER project where I was in full control i.e. loading data and reporting. I adopted...
September 4, 2020 at 12:42 pm
You're right about Type but can't change it, would require code change.
Why is an Autoincremental bigint ID a bad idea for a clustered index?
If I were to make DateAdded a...
September 4, 2020 at 8:38 am
Thanks Both
I'm pretty certain that the front-end, will make the SQL up as a string (I know SQL INJECTION!) and using a DB lib (not sure which code lib) execute...
September 3, 2020 at 9:46 pm
Viewing 15 posts - 1 through 15 (of 133 total)