Viewing 15 posts - 256 through 270 (of 325 total)
Debugging my own code and assuming I'm understanding what you mean by...
August 1, 2018 at 1:51 pm
You can just pipe multiple variables into a cmdlet, e.g.$path,$path1,$path2|Get-ChildItem
July 31, 2018 at 9:47 pm
Declare @Questions VarChar(Max) = 'Question1,Question3,Question4';
with sourceRows...
July 31, 2018 at 9:35 pm
Are you trying to do something like this?
with pivotAnswers As
(
select
PhoneNumber,
Max(InterviewerName) As InterviewerName,
Max(RetailerName) As RetailerName,
Max(StoreName) As StoreName,
Max(Address) As Address,
July 31, 2018 at 9:16 pm
Ooh, that's a handy thing to know. Partition switching, even on "non partitioned" tables is one of those underused tricks as it is, but I never realized it could be...
July 31, 2018 at 11:56 am
Then table partitioning is almost certainly the answer. Basically it works as a whole bunch of separate tables (called partitions) but under a common name so you can query from...
July 31, 2018 at 11:32 am
Sample data is a lot more useful if you provide it as SQL (Create Table... Insert Into.. etc) so we can just use it rather than doing that for you....
July 31, 2018 at 1:12 am
It would seem to suggest you're getting timeouts waiting for the SQL to run. Check how long your queries are taking to run and compare against your timeout values.
July 30, 2018 at 10:08 pm
Yeah, the sample data seems a little bit off in that regard.
Another approach which might perform better:
Select *
From
(
Select I.*, S.Sort, S.Cnt...
July 30, 2018 at 10:03 pm
Windows Authentication is Kerberos. ADFS just provides SAML support for authenticating who is connected based on external criteria. The options I can think of are:
1) Use ADFS to authenticate...
July 30, 2018 at 4:56 pm
I would expect something like
Select *
From #TEMP1 T1
Cross Apply (Select Max(Import) From #TEMP1 T2 Where T2.Import < T1.Summary And T2.Part = T1.Part) X(MaxImportDate)
July 30, 2018 at 4:00 pm
July 30, 2018 at 3:46 pm
Synonyms are probably the neatest solution in the short term, but I'd bear in mind that there's (probably) a reason other than "we felt like it" that the vendor changed...
July 30, 2018 at 3:26 pm
July 30, 2018 at 2:50 pm
Express Edition should install on any version of Windows 7, I believe - though you need the right version to match your install of Windows (i.e. 32-bit on 32-bit Windows,...
July 30, 2018 at 2:49 pm
Viewing 15 posts - 256 through 270 (of 325 total)