Viewing 15 posts - 976 through 990 (of 2,701 total)
I would look at PowerBI and Excel. You can use stored procedures and views as data sources if you want. What kinds of graphs etc did you want...
February 19, 2022 at 3:42 pm
if I got it correct the following likely to perform better - do look at the comment inside it - and as with everything test test and test again.
February 15, 2022 at 12:31 am
on top of using a non supported configuration - and potentially some licensing issues on that also (Office is not licensed to run on a server).
but that aside move that...
February 14, 2022 at 11:27 pm
you can't - dynamic sql required to do it and its not possible on user functions - see https://docs.microsoft.com/en-us/sql/relational-databases/user-defined-functions/create-user-defined-functions-database-engine?redirectedfrom=MSDN&view=sql-server-ver15
and even if you could it likely would not be advisable at...
February 12, 2022 at 7:03 pm
he/you can extract all packages to an .ispac, extract the .dtsx files from this (its just a .zip file) and then search/parse the packages for it. - that will give...
February 10, 2022 at 9:25 pm
Just as a straw poll, what if we had threads older than 1 year - latest post date <= dateadd (year, -1, getdate) - closed when someone tries to...
February 9, 2022 at 7:04 pm
I feel like that list is proof that Grant and Jeff are the same person, as they have exactly the same amount of subscriptions.
No.
You've got that all wrong....
February 9, 2022 at 7:01 pm
I did not see my name on the list but for me you can unsubscribe me from any that is older than 1 year.
should anyone post something and bump the...
February 9, 2022 at 6:42 pm
No need for UNION:
INSERT [PW].[Contract] ([ID],[ProgramID],[PAContractNum],[PAContractAmt],[PAContractStartDate],[PAContractExpirationDate],[CreatedBy],[CreatedOn],[UpdatedBy],[UpdatedOn]) VALUES (1, 8, '15FHBFPP0115', 0.0000, '2014-07-01 00:00:00', '2016-06-30 00:00:00', 'some.person', '2015-02-11 00:00:00', 'some.person', NULL)
,(2, 8, '15FHBFPP0102', 0.0000, '2014-07-01 00:00:00',...
February 7, 2022 at 7:23 pm
message is very clear - either you do those changes through SQL or you change the option that prevents you from doing the change when using the DESIGNER <--
February 5, 2022 at 11:20 am
Good one keep it up
Really? What was good about this thread? I could be wrong but I'm thinking that you're just doing a SPAM test. If I am...
February 4, 2022 at 7:23 pm
and do all tables contain identity columns?
if so you could look at restoring your db, take note of the values for all tables, set the identity to a higher value...
February 4, 2022 at 3:21 pm
I used powershell to create a script that prepares the files for bulk insert. it ensures that the columns match with the destination table. works beautifully.
You mean a...
February 4, 2022 at 12:14 am
It would be nice if they increased the DB limit in SQL Server express from 10 GB to 20 GB!
only really required if you have single tables that go...
February 3, 2022 at 5:56 pm
that happens a lot and sometimes without any explanation.
copy the remote file locally, change it as required and then copy it back to destination.
February 2, 2022 at 10:53 pm
Viewing 15 posts - 976 through 990 (of 2,701 total)