Viewing 15 posts - 1,381 through 1,395 (of 7,191 total)
Mischa
I'm afraid I can't see your screenshots. Does the script include xp_instance_regwrite, by any chance? That doesn't show an absolute path, but rather one relative to the hive...
July 11, 2017 at 2:59 am
So bal_run is the column you currently have in your result set that has wrong numbers in it? From your expected results, all you need to do is add Principal...
July 11, 2017 at 2:50 am
I think the first sentence means "I had a problem", but the rest is more difficult. Please could you post in English?
Thanks
John
July 11, 2017 at 2:30 am
You've lost me, I'm afraid. Please will you show us what the results should be? Sample data in consumable form (INSERT statements) would also be more helpful than a screenshot....
July 11, 2017 at 2:08 am
case
when (sn_type='De-Activated' and sn_status='COMP')
or (sn_type='Re-Activattion' and sn_status='N-CO')
then created_date
WHEN sn_status <> 'COMP' and sn_type='De-Activated'...
July 5, 2017 at 5:50 am
June 29, 2017 at 7:51 am
Do you have SET QUOTED_IDENTIFIER OFF anywhere in your code, or is your ODBC driver configured to set it to OFF?
John
June 27, 2017 at 3:42 am
Start with sys.sequences, which exposes most of the information you're looking for.
John
June 26, 2017 at 3:40 am
I know the example you posted is probably a massive simplification, but for that you don't need a loop at all. It's likely that you'll be able to rewrite your...
June 23, 2017 at 2:01 am
You need to use a splitter function to split the string into its individual elements.
John
June 22, 2017 at 9:27 am
Luis Cazares - Thursday, June 22, 2017 7:55 AMThat looks so similar to mine 😛
Almost identical......
June 22, 2017 at 8:00 am
Something like this, maybe. Although I'm a bit puzzled how there are two base tables in your execution plan, but only one in the query you posted. If any of...
June 22, 2017 at 7:33 am
You've got some large differences between the estimated and actual number of rows for those clustered index scans, suggesting that your statistics might not be up to date. And the...
June 22, 2017 at 7:14 am
Do you have the necessary indexes in place on the table to support this query?
John
June 22, 2017 at 4:39 am
Viewing 15 posts - 1,381 through 1,395 (of 7,191 total)