Viewing 15 posts - 931 through 945 (of 2,654 total)
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
Thank you so much!!
It is really interesting how the two approaches are very different (Import Data vs Bulk Insert). That column you mentioned has never been a problem when...
February 2, 2022 at 10:42 pm
the bulk insert options you used were just a sample - you needed to adjust to your own needs.
you also can't have extra columns on the destination table - if...
February 2, 2022 at 8:30 pm
If I couldn't keep every file in a local folder - so that I could use a simple File.Exists() in C# to determine if the file has already been...
January 30, 2022 at 5:39 pm
Curious - why do you need to create a script task and execute a SQL query in that script task? If this is a one-time call to get/set some...
January 29, 2022 at 7:59 pm
Viewing 15 posts - 931 through 945 (of 2,654 total)